Solved

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

Posted on 2008-10-08
6
1,592 Views
Last Modified: 2008-10-17
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
Comment
Question by:vedant0500
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22668759
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
 
LVL 9

Expert Comment

by:michofreiha
ID: 22669028
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
 

Author Comment

by:vedant0500
ID: 22669212
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22669304
>dbname
did you also grant to the mysql (system) database?
will be required, AFAIK
0
 

Author Comment

by:vedant0500
ID: 22694165
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
 

Accepted Solution

by:
vedant0500 earned 0 total points
ID: 22696900
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question