Ubuntu mysql root password

This is a guide on how to set Ubuntu mysql root password. Mysql root password is not the same as Linux root password. They do not share the same account. Mysql has its own root user.

If you didn't choose to install mysql during Ubuntu installation setup, you can install it now. It's just two simple steps. Check my previous post, Ubuntu mysql install guide.

You can use the command below to set mysql root password:

luzar@ubuntu:~$ sudo mysqladmin -u root password new_password

You need to restart the mysql server then:

luzar@ubuntu:~$ sudo /etc/init.d/mysql restart