Set mysql’s root password on fresh copy from SolusVM OS template

On SolusVM, your host may provide you with OS templates such as “Ubuntu 10.04 LTS LAMP” and you click-install it to your VPS. Now how do you change its mysql’s root password? simple, run these two commands on SSH after doing

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.