Search

Language:  
Search for:

Available article translations:

[How to] How can I access MySQL databases in Plesk?

APPLIES TO:
  • Parallels Plesk 12.0 for Windows

Symptops

How can I access MySQL databases in Plesk?

Resolution

Users can access their MySQL databases by means of PHPMyAdmin while logged into the Plesk interface. After selecting the domain, click "Databases," select the database you wish to access, and push the "DB WebAdmin" button.

The server administrator can access any MySQL database from the command line. Log in to the server via SSH/RDP and use the command:

mysql  -uadmin -p`cat /etc/psa/.psa.shadow` DATABASE_NAME (Linux)

%plesk_bin%\plesksrvclient --get  <== this will retrieve admin password
%plesk_dir%\MySQL\bin\mysql -uadmin -p<password_from_the_previous_step> DATABASE_NAME  (Windows)



c81e59b61af9dca603ba03b14aabe968 56797cefb1efc9130f7c48a7d1db0f0c 4bd416dd9da208376c20e13782bef971 42844a8183c58f5bd71c7d59929707e6 230ec28618f20889fbaa0a73287fbabb

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