Plesk mysql root password?

steitieh

Well-known member
Joined
Apr 23, 2014
Messages
113
Points
18
I have just installed Plesk on a VPS, how can I log into MySQL as root user in Plesk? I want to find root password. Does Plesk have default root password? If so where is storing this?
 

LJSHost

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
I'm not 100% on this but I think plesk renames for root user to "admin" Plesk will also not allow you to use a password in plain text it only accepts the encrypted version.

You can show unencypted password using

Code:
 /usr/local/psa/bin/admin --show-password

Code:
 cat /etc/psa/.psa.shadow
This will show you the password encrypted which you can use to login.

Try this to login

Code:
 mysql -u admin -p`cat /etc/psa/.psa.shadow`

Like I said not 100% sure about all this, Plesk might of made changes in the current version, but this has worked for me in older versions of the panel.

Virtubox would be the best person to talk to about Plesk, he's kind of our resident Plesk guru :D
 
Older Threads
Replies
8
Views
6,364
Replies
6
Views
20,290

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top