CODEWITHSUNDEEP
mysqlpasswordsadminrootplesk
Berkay Yıldız
Berkay Yıldız

Reputation: 450

I don't know my server's mysql admin password

Hi I will repair my tables in ssh but it want mysql admin password.

Admin password different then my plesk admin or root password.

I did't change admin mysql password.

/usr/local/psa/bin/admin --show-password this password isn't work

I want to get password or change but I don't know it.

I'm using plesk if I change password direct at mysql.users probably I cant login plesk.Is it wrong?

Please help me how can get or change this password?

https://i.sstatic.net/xz6Mr.png

Upvotes: 0

Views: 525

Answers (1)

Oleg Neumyvakin
Oleg Neumyvakin

Reputation: 10282

You can use string stored in /etc/psa/.psa.shadow as mysql user admin password.

For example, to upgrade mysql tables try this command:

# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

I'm using plesk if I change password direct at mysql.users probably I cant login plesk.

It's true.

Upvotes: 1

Related Questions