What is mysql user at my VPS?

[KunL]

My VPS vendor told me that the mysql user after Plesk installation is admin. My question is do we still have the mysql root user? And what is its password?
Thanks.

 

[IgorG]

No. root user is disabled and amin user have all the same permissions as root. Password for admin user the same as password for login as admin to Plesk Panel. You can find it with

cat /etc/psa/.psa.shadow

And login to mysql with

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

 

[DarrenT]

How do I adjust the privileges of MySQL users?

Every user I create thru the Plesk interface seems to have full permissions.

However, use the mysql commandline client and retrieve the users table, I see that all users have all privileges set to N, except for admin.

Can someone explain how Plesk makes MySQL user administration different from normal?

Thanks.

 

[IgorG]

Admin's account has been created during Plesk installation by installation scripts. As I remember it is just converted root user. Therefore all admin's privileges have been added during installation too.

 

[DarrenT]

Privileges tab in phpMyAdmin?

Hi,
When I get into phpMyAdmin via the Webadmin link at

Home>Domains> example.com >Databases>
Users for database db01 on domain example.com


I cannot find the Privileges tab.
Is it because I am logged into MySQL as a user other than admin?
How do I know what MySQL user I am?
How do I login as admin?
I was not asked to login.

EDIT:
My VPS hosting provider has answered my question.
In order to use phpMyAdmin as admin (and get the Privileges tab), you need get to Webadmin via the following path in Plesk:

Home > Server > Database servers > Local MySQL server > Databases > Webadmin

 

[littlealex]

@DarrenT - thanks

Thank thank you - 4.5 hours of messing around trying to find the answer you worked out - thank goodness for that - cheers dude!!!!!!!!!!!!