Re: GRANT and mysql.user table

2005-07-05 Thread Paul DuBois
At 16:57 -0700 7/4/05, l'[EMAIL PROTECTED] wrote: I tried as root having GRANT ALL PRIVILEGES with GRANT OPTION to change the privilege of a user: GRANT ALL ON mydb.* TO myUser; The result of this statement is that the query is OK and 0 rows are affected. WHen I look at the mysql table holding

GRANT and mysql.user table

2005-07-04 Thread l'[EMAIL PROTECTED]
I tried as root having GRANT ALL PRIVILEGES with GRANT OPTION to change the privilege of a user: GRANT ALL ON mydb.* TO myUser; The result of this statement is that the query is OK and 0 rows are affected. WHen I look at the mysql table holding the grants: user, the myUser row is unchanged.

Re: GRANT and mysql.user table

2005-07-04 Thread Michael Stassen
l'[EMAIL PROTECTED] wrote: I tried as root having GRANT ALL PRIVILEGES with GRANT OPTION to change the privilege of a user: GRANT ALL ON mydb.* TO myUser; The result of this statement is that the query is OK and 0 rows are affected. WHen I look at the mysql table holding the grants: user, the