Super privileges

[Aerobaticrug]

I need to run a query on one of my databases with super privileges, how do I do it? I can't see anyway to change user in phpmyadmin.

 

[IgorG]

Use command

mysql -P3306 -uadmin -p<plesk_admin_password> database_name

for login to your database as administrator.

 

[Aerobaticrug]

Thanks for that. Only problem is I get a Could not open required defaults file: C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\my.ini Fatal error in defaults handling. Program aborted.

It then asks for a password - which I assume is the admin one for the panel, then gives me access denied when i enter it. Any thoughts?

 

[IgorG]

Are you sure that Plesk installed correctly there and works fine?

 

[Aerobaticrug]

Yeah, it seems to have installed fine - panel works ok, phpmyadmin etc, several websites.