Home > how-to, Tips & Tricks > ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)

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

July 27th, 2009 Leave a comment Go to comments

Today I got the error below :

1

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

after typing :

1

mysql -u root

I don’t know why ? but I know how to solve it.
First of all let’s disable password authentication :
Stop your MySQL daemon:

1

/etc/init.d/mysql stop

or

1

/etc/init.d/mysqld stop

Then run the following command line in background :

1

mysqld_safe --skip-grant-tables &

Secondly run :

1

mysql -u root

Finally, In your MySQL command line prompt issue the following command:

1
2
3
4

USE mysql;
UPDATE user SET password=PASSWORD("my_password") WHERE user="root";
FLUSH PRIVILEGES;
EXIT

Password is now reset to my_password. So just restart your MySQL server using :

1

/etc/init.d/mysql restart

or

1

/etc/init.d/mysqld restart

and use your new password to authenticate :

1

mysql -u root -p

All that remains is to enter your password.

Categories: how-to, Tips & Tricks Tags: ,
  1. Gbenga
    August 27th, 2009 at 22:55 | #1
    Reply | Quote

    still not working i have tried the steps over and over

  2. el arbi
    December 25th, 2009 at 07:12 | #2
    Reply | Quote

    hello can you telle me pleaze how can we do it in windows (with wamp)

  3. Oussama
    June 4th, 2010 at 10:15 | #3
    Reply | Quote

    Hello,
    I get this error on WAMP(Windows) when i tried to connect to the database via phpMyAdmin
    you can do the following :

    - go to %WAMP_DIR%appsphpmyadmin2.11.6config.inc.php file
    - change the value of $cfg[\'Servers\'][$i][\'password\'] to your password
    - restart the services (Apache & MySQL)

  4. geomatag
    September 11th, 2010 at 02:43 | #4
    Reply | Quote

    Thanks a lot for this. I followed the procedure exactly and now i can go in the mysql database. I was beggining to loose hope reading tens of articles about this ERROR. Thank God i found your website. I’ve already bookmarked it.
    Thanks again

  1. No trackbacks yet.