MySQL User root doesn't work?

[southy]

Hi,

in order to install, I changed the MySQL Root-User's Password to ''.
Now I want to redo this for obvious security reasons.
But I can't login as (mysql)root anymore. Neither '' nor any other password used on the system seem to work.

Plesk added it's own user: admin wich works fine.

Could it be that the old User "root" doesn not exist anymore? Did Plesk just rename it? How can I find out if there's still a user 'root' without a password?

southy

 

[DerFalk]

Just use the "admin" and the same Password like the Plesk Admin...

 

[southy]

Thanks, that was what I hoped for, then this is not a security issue anymore.

thx,
southy

 

[breun]

The Plesk installation indeed removes the root user and adds an admin user. Run the following to see a list of all mysql users:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "SELECT user FROM mysql.user;"

There shouldn't be a user called 'root' in this list on a Plesk box.

 

[southy]

No, root is not in the list.

Great! Thank you so much for your help. I was a little worried because I couldn't change that sql-root-password.

Thanks and greetings,

Southy