• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

MySQL User root doesn't work?

southy

Basic Pleskian
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
 
Just use the "admin" and the same Password like the Plesk Admin...
 
The Plesk installation indeed removes the root user and adds an admin user. Run the following to see a list of all mysql users:

Code:
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.
 
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
 
Back
Top