grant MySQL user full right on everything

Try modifying your syntax slightly.

Change the user name from xyz@localhost to 'xyz'@'localhost' + see if your GRANT works now.

David,

I tried that before, still doesn;'t work,  that's why I use this.


GRANT ALL PRIVILEGES on *.* TO xyz@localhost;

Thomas.

I just want to create another account with the same as root permisson, so I do this:

mysql> CREATE USER 'finley'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'finley'@'localhost'
    ->     WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';

?

hi,

when doing this:

GRANT ALL PRIVILEGES ON *.* TO 'finley'@'localhost' WITH GRANT OPTION;

I got:

ERROR 1133 (42000): Can't find any matching row in the user table

from my point of view, that login doesn't exist, I did change finley to a test account which I already created ( I can login using that account by Toad for MySQL, it works.).

I also tried to login using that test account using command mode and it can login too. can't see why. I can do :

select @@version;

it returns result.s

finally found out why:

select host, user from mysql.user;

shows me that the user account is on the host '%' any reason ?

I create the user account by doing this:

CREATE USER finley  IDENTIFIED BY 'some_pass'; instead of CREATE USER 'finley'@'localhost' IDENTIFIED BY 'some_pass';

any diff ?

so finally I do this:

CREATE USER 'finley'@'$' IDENTIFIED BY 'some_pass';

this is it. and Toad for MysQL verified that it works.

tks all even I figure it out myself.