Search

Language:  
Search for:

Available article translations:

What is the root password for MySQL?

Article ID: 427, created on Oct 6, 2008, last review on Feb 27, 2015

APPLIES TO:
  • Parallels Plesk for Linux/Unix
  • Parallels Plesk for Windows

Question

What is the root password for MySQL?

Answer

Parallels Plesk renames root mysql account to admin when Plesk is installed.
To get root privileges in mysql simply login with the admin username instead. The password is the same as the admin password in Parallels Plesk.

On server with Parallels Plesk versions 8.x, 9.x and above admin password is stored in file /etc/psa/.psa.shadow . Use the following command to get the password:

    ~# cat /etc/psa/.psa.shadow

Since Plesk 10 admin password stored in file /etc/psa/.psa.shadow is encrypted. Use the following command to get admin password in plain text:

Linux:

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

Windows:

    %plesk_bin%\plesksrvclient --get  

Despite version of Parallels Plesk you may use the following command to login to mysql with root privileges:

Linux:

    ~# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

Windows:

    %plesk_dir%\MySQL\bin\mysql -uadmin -p<password_from_the_previous_step> DATABASE_NAME

Search words:

root password for MySQL

root password for MySQL




56797cefb1efc9130f7c48a7d1db0f0c c81e59b61af9dca603ba03b14aabe968 9f8baf78266b4e54525d1c6bf06305a5 42844a8183c58f5bd71c7d59929707e6

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Server Virtualization
- Odin Cloud Server
- Odin Containers for Windows 6.0
- Odin Virtuozzo Containers
Automation
- Odin Automation
- Odin Automation for Cloud Infrastructure
- Odin Business Automation Standard
- Odin Virtual Automation
- Odin Plesk Panel Suite
- Web Presence Builder
- Odin Plesk Automation
- Odin Small Business Panel
- Value-added Services for Hosters
- Odin Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification