How can I find out Mysql root password?

laurence · Oct 7, 2016

For any reason I forgot Mysql root password and could not log into mysql server on my vps, how can I find this out? Is there any file where this password is stored?

ValeriaMxc · Oct 7, 2016

If you are using cPanel, run this command

Code:

cat /root/.my.cnf

You can get password like this

Code:

[client]
user="root"
password="u1lHDR2bfmrqi"

If you are using Directadmin, run this command

Code:

cat /usr/local/directadmin/conf/mysql.conf

If you are using Plesk, run this command

For Linux:

Code:

# /usr/local/psa/bin/admin --show-password

For Windows:

Code:

"%plesk_bin%\plesksrvclient" -get

UWH-David · Oct 7, 2016

laurence said:
For any reason I forgot Mysql root password and could not log into mysql server on my vps, how can I find this out? Is there any file where this password is stored?

For most Linux platforms this will be how you perform this:

Code:

/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit
/etc/init.d/mysql stop
/etc/init.d/mysql start

and if you are using cPanel, you can just change the MySQL pass via the web host manager interface very quickly.

How can I find out Mysql root password?

laurence

Member

ValeriaMxc

New member

IgorG

Member

UWH-David

Member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud