• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1819
  • 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
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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