How to change MySQL Password/phpmyadmin Linux

[Dev Blaze]

If this is the first time you have logged into your server through this manner, you will be prompted to accept the identification of this server. Once you do this and are logged in, perform the following commands to reset the administrator password.

Step.1

#service mysqld stop

Step.2

#/usr/bin/mysqld_safe --skip-grant-tables &

This starts the MySQL daemon in the background and skips the authentication mechanisms.

Step.3

#mysq

 

 

Step.4

#use mysql;

Step.5

#update user set password=password('newpassword') where user='root' and host='localhost';

Step.6

#flush privileges;

Step.7

#quit

Step.8

#service mysqld stop

Step.9

#service mysqld start

Step.10

#exit

Dev Blaze ™ 

 

[ccjosh]

Actually, If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:

 

mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use the following command:

mysqladmin -u root -p'oldpassword' password newpass

Source: Nixcraft

Edited August 7, 2013 by ccjosh

[Asura]

Hi D3vBlaze,

ccjosh's method is correct for changing MySQL account passwords; your method is only if the user absolutely forgets his password and has no access to SQL, which is why it requires to be run on safe mode.