IndianWebPortal.com

Something Different In Linux

Home » mysql » reset mysql password in plesk

reset mysql password in plesk

Posted by Rishikesh Vispute Categories: mysql, Plesk

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

Solution :

To find password for user admin, run
[root@server22 ~]# cat /etc/psa/.psa.shadow
FfRBehWy
[root@server22 ~]#

To login to MySQL

mysql -u admin -pFfRBehWy

For example

[root@server22 ~]# mysql -u admin -pFfRBehWy
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2555 to server version: 4.1.20
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql>

To login with out password, create a file /root/.my.cnf

vi /root/.my.cnf

With following content

[mysql]
user = admin
password = FfRBehWy
 
[mysqldump]
user = admin
password = FfRBehWy

This will allow you to use mysql and mysqldump with out providing passwords.


Popular Posts

remove index.php fro

How to remove index.php from url in magento Ans : If you ...

PHP-Java bridge on p

  What is php-java bridge? The php-java bridge is the php ...

Set expiration for y

If you want to set the expiration to your site ...

Warning: Parameter 1

Error: Warning: Parameter 1 to modMainMenuHelper::buildXML() expected to be a ...

domain pointing to e

If you domain uses external MX record and it is ...