Applicable to:
- Plesk for Linux
- Plesk for Windows
Question
How to enable direct access to phpMyAdmin that is shipped in Plesk in order to skip login to Plesk page in https://<Plesk-server-host-name-or-IP>:8443> Tools & Settings > Database Servers > Access This Server via DB Webadmin?
Answer
It is possible to enable direct access to Plesk server phpMyAdmin page over https://<Plesk-server-host-name-or-IP>:8443/phpmyadmin link.
The database user login and password are still required to enter this page.
-
Install the Panel.ini Editor extension in Plesk: Extensions > Extensions Catalog > search for Panel.ini Editor or expand View All under Server Tools > Install.
-
Click Go To Extension next to Panel.ini Editor.
-
Switch on Editor tab and add the following lines in Content section:
CONFIG_TEXT: [databaseManagement]
features.phpMyAdmin.loginForm.enabled = on
-
Click Save.
-
This makes it possible to access phpMyAdmin by browsing the following URL:
CONFIG_TEXT: https://<Plesk-server-host-name-or-IP>:8443/phpmyadmin
If URL shows error, clear browser cache.
-
The database user login screen will appear:
-
Log into the database with the database username and password.
Note: If the error "Cannot connect: invalid settings." appears, restore the original panel.ini file or make sure that it is correct:
-
Rename the existing file
panel.ini:# mv /usr/local/psa/admin/conf/panel.ini{,.old}
-
Copy it from the template:
# cp /usr/local/psa/admin/conf/panel.ini.sample /usr/local/psa/admin/conf/panel.ini
-
Edit the file using vi and add the lines for 4. at the end:
# cat -n /usr/local/psa/admin/conf/panel.ini | tail -n 2
74 [databaseManagement]
75 features.phpMyAdmin.loginForm.enabled = on
It should look like the following in Panel.ini editor:
Comments
2 comments
With Firefox the following link may also help:
https://<Plesk-server-host-name-or-IP>/domains/databases/phpMyAdmin/index.php?db=databasename
@Peter
I order to use this link it is required to log in to Plesk as 'admin' user first.
Please sign in to leave a comment.