I'm having a problem changing user permissions in mysql with the root user, in Debian.
I can usually access the terminal:
$ mysql -u root -p
So he asks me the root password, I put the password and normal access. However, when I try to execute the command:
mysql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'senha_do_usuario' WITH GRANT OPTION;
It returns me the following message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
And if I try the command:
CREATE USER 'user'@'%' IDENTIFIED BY 'senha';
it returns the error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
I'm trying to free access to the root user, or even create another user for access from other machines on the network.