Access denied for user: ‘root@localhost’ (Using password: NO) OR Access denied for user: ‘root@localhost’ (Using password: YES)


Why are you looking at this wiki page?

Are you looking at this page because you cannot access the mysql server installed on your pc/server when you were trying to see if it works well? Or do you receive error messages like the following? :

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

or

ERROR 1045: Access denied for user: 'root@localhost' (Using 
password: YES)

How can I reset my MySQL password?
Following this procedure, you will disable access control on the MySQL server. All connexions will have a root access. It is a good thing to unplug your server from the network or at least disable remote access.

To reset your mysqld password just follow these instructions :

Stop the mysql demon process using this command :
sudo /etc/init.d/mysql stop
Start the mysqld demon process using the –skip-grant-tables option with this command
sudo /usr/sbin/mysqld –skip-grant-tables –skip-networking &
Because you are not checking user privs at this point, it’s safest to disable networking. In Dapper, /usr/bin/mysgld… did not work. However, mysqld –skip-grant-tables did.

Afte It Run sudo /etc/init.d/mysql start

1) start the mysql client process using this command
mysql -u root
2) from the mysql prompt execute this command to be able to change any password
FLUSH PRIVILEGES;
3) Then reset/update your password
SET PASSWORD FOR root@’localhost’ = PASSWORD(‘password’);
4) If you have a mysql root account that can connect from everywhere, you should also do:
UPDATE mysql.user SET Password=PASSWORD(‘newpwd’) WHERE User=’root’;
5) Alternate Method:
USE mysql
UPDATE user SET Password = PASSWORD(‘newpwd’)
WHERE Host = ‘localhost’ AND User = ‘root’;
6) And if you have a root account that can access from everywhere:
USE mysql
UPDATE user SET Password = PASSWORD(‘newpwd’)
WHERE Host = ‘%’ AND User = ‘root’;
7) For either method, once have received a message indicating a successful query (one or more rows affected), flush privileges:

8) FLUSH PRIVILEGES;
Then stop the mysqld process and relaunch it with the classical way:

sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
When you have completed all this steps ,you can easily access to your mysql server with the password you have set in the step before. An easy way to have a full control of your mysql server is phpmyadmin (www.phpmyadmin.net), software made in php that can give you a web interface that can be very usefull to people that havent got a lot of confidence with bash .To install phpmyadmin on you server you will need to have 4 things:

web server apache
php
mysql server/mysql client installed
php_mysql support for apache
All packages can be found browsing synaptic.

Refrenced by [https://help.ubuntu.com/community/MysqlPasswordReset]

Advertisements

I am Senior Software Engineer. I love reading, writing, sharing,developing, hiking, movies, trips, mountains, brooks, hills etc.

Posted in Data Base, Mysql

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

StackOverFlow
Categories
Archives
%d bloggers like this: