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