Access denied for user ‘root’@’localhost’ (using password: NO) 

This error pops us mostly while trying to access your MYSQL database

Resolution:

 [root@server ~]# /etc/init.d/mysqld stop
 Stopping MySQL:                                          [ OK ]
 [root@server ~]# mysqld_safe –skip-grant-tables &
 [1] 24359
 [root@server ~]# Starting mysqld daemon with databases from  /var/lib/mysql
 [root@server ~]# mysql -u root
 Welcome to the MySQL monitor. Commands end with ; or \g.
 Your MySQL connection id is 1
 Server version: 5.0.77 Source distribution
 Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
 mysql> show databases;
 +——————–+
 | Database |
 +——————–+
 | information_schema |
 | mysql |
 | openfire |
 +——————–+
 3 rows in set (0.13 sec)
 mysql> use mysql;
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A
 Database changed
 mysql> show tables;
 +—————————+
 | Tables_in_mysql |
 +—————————+
 | columns_priv |
 | db |
 | func |
 | help_category |
 | help_keyword |
 | help_relation |
 | help_topic |
 | host |
 | proc |
 | procs_priv |
 | tables_priv |
 | time_zone |
 | time_zone_leap_second |
 | time_zone_name |
 | time_zone_transition |
 | time_zone_transition_type |
 | user |
 +—————————+
 17 rows in set (0.00 sec)
 mysql> update user set password=PASSWORD(“new_paswd”) where User=’root’;
 Query OK, 3 rows affected (0.05 sec)
 Rows matched: 3 Changed: 3 Warnings: 0
 mysql> flush privileges;
 Query OK, 0 rows affected (0.04 sec)
 mysql> quit
 Bye
 [root@server ~]# /etc/init.d/mysqld restart
 STOPPING server from pid file /var/run/mysqld/mysqld.pid
 102675 04:17:15 mysqld ended
 Stopping MySQL:                                          [ OK ]
 Starting MySQL:                                          [ OK ]
 [1]+ Done mysqld_safe –skip-grant-tables
 root@server ~]# mysql -u root -p
 Enter password:
 Welcome to the MySQL monitor. Commands end with ; or \g.
 mysql> quit
 Bye
Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: