Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1894
  • Last Modified:

1045 - Access denied for user 'root'@'202.xx.xxx.xx' (using password: YES)

I have a cent os machine with MYSQL when I login using putty and using the command mysql -u root -p after entering the root password I am able to login and see and use all the databases but the same connection when done using MYSQLADMIN or Navicat 8 Lite on windows we get the following error 1045 - Access denied for user 'root'@'202.xx.xxx.xx' (using password: YES)
0
vedant0500
Asked:
vedant0500
  • 3
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you will have to GRANT the permissions needed to 'root'@'202.xx.xxx.xx' , so that root has remote permissions...
dev.mysql.com/doc/en/GRANT.html
0
 
michofreihaCommented:
Under privileges section in phpMyAdmin edit the user root and change the Host entry from localhost or anything else to Any Host and try...
0
 
vedant0500Author Commented:
I gave the following command after login in from root grant all on dbname.* to root
grant all on dbname.* to root@localhost
grant all on dbname.* to 'root' @ '202.xx.xxx.xxx'

But still the same error
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>dbname
did you also grant to the mysql (system) database?
will be required, AFAIK
0
 
vedant0500Author Commented:
Please specify the commands to be used, as I am a newbie using Mysql. I am able to login using mysql -u root -p
0
 
vedant0500Author Commented:
The issue that i was unable to login to the DBusing mysqladmin was because the default anonymous user root was not set with password and when I tried login with root and blank password it worked. I se the password for root and now using that password I am able to login.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now