Please fix root access to MySql databases

[LionGate]

I am trying to run programs that require me to configure a database directly through SSH but cannot run MySql database commands as "root" because Plesk assigns root access to "admin." It would be helpful if Plesk would allow a method of creating user root for SSH commands instead of having to use admin. I'm unable to do any database work from the SSH command line with Plesk 11.

Running Centos6 with Plesk 11.

 

[SibProgrammer]

For Plesk 11.5 use "plesk db" command.
For older versions of Plesk use the following command: mysql -uadmin -p`cat /etc/psa/.psa.shadow`

 

[LionGate]

Thanks -- this takes me to the mysql> prompt. I can do what I need to now.