DevOps Technology Blog | ERROR 1045 (28000): Access denied for user 'root'@'10.0.1.14'

ERROR 1045 (28000): Access denied for user 'root'@'10.0.1.14'

by XDK 23. August 2019 21:24

Explanation:

The mention exception occurred while granting privileges to the MySQL instance database.

Exception:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.1.14';
ERROR 1045 (28000): Access denied for user 'root'@'10.0.1.14' (using password: YES)

Solution:

Login to the data tier where MYSQL server --> Login to MYSQL --> Execute the following steps.

        ubuntu@ip-10-0-2-227:~$ sudo mysql -u root -p

        mysql> select current_user();
        +----------------+
        | current_user() |
        +----------------+
        | root@localhost |
        +----------------+
        1 row in set (0.00 sec)

        mysql> SELECT host,user,Grant_priv,Super_priv FROM mysql.user where user = 'root';
        +-----------+------+------------+------------+
        | host | user | Grant_priv | Super_priv |
        +-----------+------+------------+------------+
        | localhost | root | Y | Y |
        | 10.0.1.14 | root | N | Y |
        +-----------+------+------------+------------+
        2 rows in set (0.00 sec)

        mysql> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
        Query OK, 1 row affected (0.00 sec)
        Rows matched: 2 Changed: 1 Warnings: 0

        mysql> SELECT host,user,Grant_priv,Super_priv FROM mysql.user where user = 'root';
        +-----------+------+------------+------------+
        | host | user | Grant_priv | Super_priv |
        +-----------+------+------------+------------+
        | localhost | root | Y | Y |
        | 10.0.1.14 | root | Y | Y |
        +-----------+------+------------+------------+
        2 rows in set (0.00 sec)

        mysql> FLUSH PRIVILEGES;
        Query OK, 0 rows affected (0.00 sec)

  • Try again

        mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.1.14';

 

Tags:

MySQL

Comments are closed

About the author

My name is Xavier Dilip Kumar Jayaraj having 13+ years of IT experience which includes solid experience and depth Knowledge in Application Life Cycle Management, Configuration Management, Implementation and Support using TFS on-premises and Azure DevOps. I have invested in gaining DevOps knowledege to expertise with Cloud Computing providers namely Microsoft Azure and Amazon Web Services in recent years. I am very positive to learn and adapt emerging technologies to client’s environment.

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

DevOps Tools

ALM tools:
Azure DevOps
IBM Rational
CA Agile Central-Rally
CollabNet VersionOne

Configuration tools:
• Puppet
• CHEF
• AWS OpsWorks
• Ansible

Build automation tools:
Apache Ant 
Apache Maven
Boot
Gradle
Grunt
MSBuild
Waf

Continuous Integration tools:
Bamboo
Buildbot
Hudson
TeamCity

Testing tools:
Selenium
Watir
Wapt
ApacheJMeter
QTest

Version control system tools:
Subversion
Team Foundation Server
GIT
Mercurial
Perforce

Code review tools:
Crucible
Gerrit
GitHub
Bitbucket Server

Continuous Delivery/release management tools:
XL Release
ElectricFlow
Serena Release
Octopus Deploy