GRANT ALL PRIVILEGES ON *.*

[spotter]

Hi everyone, I am trying to create a root user in phpmyadmin, and grant all privileges.

i am executing the following sql command

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' WITH GRANT OPTION;

the sql query is accepted, but when i try to connect to the database i get the error
Access denied for user 'root'@'localhost' (using password: YES)

please help

[JJ_Tagy]

Looks like it is telling you your password is wrong. Maybe you shouldn't manually enter a hash.

[Altrea]

Don't use the Wildcard (%) for host.
Read more about priority of MySQL users here: viewtopic.php?f=16&t=52384&p=201304#p201304