Whenever i try to connect to the server i get this:
Access denied for user 'root'@'localhost' (using password: YES)
I tried resetting the password with this that i used from mysql official site:
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;
If i type
mysql -pi always get the same message, even if i try GUI programs to connect to server.
I can only start and stop the server, nothing else, i always get denied access.
Its localhost server, i also tried to commenting out the
bind-address in the confi file but still getting denied access.
I dont know what else to do.