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

Posted on by

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

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

Related posts:

  1. Installing MySQL 5.1 on Ubuntu
  2. How to change password in linux console?
  3. How to Install Apache, PHP and MySQL on CentOS
  4. Download files from a http authenticated directory using wget
  5. Intall Apache, MySQL and PHP on Ubuntu 8.10

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>