Mysql access denied for user using password
 

Hi
i created mysql user root to be access by my firewall inetrface ipaddress

CREATE USER 'root'@'58.98.xx.xx' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'58.98.xx.xx' WITH GRANT OPTION;


My Password has not been created for user@58.98.xx.xx .Can anyone help How can i solve the problem

Hi sanjay87

I think you didn't take the proper steps to allow root on the ip address, because
you can't create "root" user again (it already exists) and then set it's privileges.
You can do that for new username like you wrote.

So to define "root" password you should use mysqladmin command (set/change root password).
or if you already did it, then
define for "root" privileges like:
Take a look at enable remote user on database or here (maybe clearly explained)

So I hope this will get you what you want.

good luck

One that always catches me out, remember to do the following after any operations like that: