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
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