• VMware

    Learn about VMware virtualization for its products like vsphere ESX and ESXi, vCenter Server, VMware View, VMware P2V and many more

  • Linux

    Step by step configuration tutorials for many of the Linux services like DNS, DHCP, FTP, Samba4 etc including many tips and tricks in Red Hat Linux.

  • Database

    Learn installation and configuration of databases like Oracle, My SQL, Postgresql, etc including many other related tutorials in Linux.

  • Access denied for user 'root'@'localhost' (using password: NO)

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


     [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

     [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

    Deepak Prasad

    is a techie and an author who is still trying to survive in this IT generation with very little knowledge he has on Linux/Unix, VMware, SAN Storage, Automation, networking etc

    You can follow him on Facebook or Google+

    Do you also have something to share here?
    Join GoLinuxHub Team as an Author, Click here for more information
    Access denied for user 'root'@'localhost' (using password: NO) Access denied for user 'root'@'localhost' (using password: NO) Reviewed by Deepak Prasad on Friday, May 03, 2013 Rating: 5

    No comments:

    Powered by Blogger.