Sunday, October 11, 2015

MySQL Database login Access denied for user 'root'

MySQL Database login Access denied for user 'root'


Trying to login MySQL Database on Linux system getting Access denied issue in root user.

Error:-

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO).

Resolution:-

Try command on Linux prompt mysql -u root -p

[root@eznag bin]# ./mysql -u root -p

Enter password: --> Type Root Password

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.52 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from nagios_servicechecks;
ERROR 1046 (3D000): No database selected
mysql> 






No comments:

Post a Comment

Gitlab Automation Project Showcase

My GitLab Projects Showcase 🚀 Welcome to my portfolio of GitLab projects. Each repository reflects my journey as an engineer, focusing...