phpmyadmin root access

[apogee]

Where can I log into phpmyadmin as root?

I need to make some changes to the permissions in the mysql table...

I've enabled this: https://help.directadmin.com/item.php?id=2117

 

[Richard G]

Did you try loggin in from within the DA panel in that case?
Use username: da_admin
Has the same rights as root.

 

[apogee]

No, I see no option, If I try to use the /phpmyadmin at the end it redirects to DA (and load forever). Or if I append it to the hostname I get "Access to phpMyAdmin is only allowed from control panel.", I need Feature 2117 enabled for for safety reasons.

Isn't there an option like in cpanel to access the phpmyadmin as root?

 

[zEitEr]

I guess no, you need to disable SSO for phpmyadmin and/or allow public access:

./build set phpmyadmin_public yes
./build phpmyadmin
./build rewrite_confs

connect as root/da_admin, do the things you need, and then enable SSO back and/or disable public access:

./build set phpmyadmin_public no
./build phpmyadmin
./build rewrite_confs

 

[apogee]

Thanks, is this the only way to connect as root? I do not want phpmyadmin to be publicly available...

 

[zEitEr]

Either set phpmyadmin temporary public, or connect as root/da_admin via mysql CLI or by any other Web-UI or GUI using 3306 port