How can I login to phpmyadmin as root?

S

Shira

Verified User
Joined
Jul 5, 2020
Messages
18
I want to log in phpmyadmin as root to see a list of all the username_database entries. If I click on phpmyadmin from DA as Admin it doesn't do anything. Thanks
 
Just use login details from
Code: 
cat /usr/local/directadmin/conf/my.cnf
 
smtalk said:
Likely your browser (Sarafi?) blocking pop-up? Try clicking once more there :) If that doesn't still work - check the browser settings.

To open it manually, you may just access https://yourdomain.com/phpMyAdmin.
Click to expand...
Trying manually says "Access to phpMyAdmin is only allowed from control panel."

Popups are allowed for the DA domain. If I right-click on phpmyadmin>open in new tab it just loads the main DA dashboard again.
 
Just take any domain on your server and add /phpmyadmin behind it.
example.com/phpmyadmin

If you use the user/password from my.cnf you can log in as da_admin accessing all databases.
 
Wanabo said:
Just take any domain on your server and add /phpmyadmin behind it.
example.com/phpmyadmin

If you use the user/password from my.cnf you can log in as da_admin accessing all databases.
Click to expand...
Thanks
 
Shira said:
Access to phpMyAdmin is only allowed from control panel.
Click to expand...
You have this on

more info here


  • You can make /phpMyAdmin SSO-only accessible (no user/pass allowed) using:
    cd /usr/local/directadmin/custombuild
    ./build update
    ./build set phpmyadmin_public no
    ./build phpmyadmin
    such that any access to /phpMyAdmin manually would throw:
    Access to phpMyAdmin is only allowed from control panel.
Click to expand...
 
You must log in or register to reply here.
Back
Top