root

Ubuntu Server Auto Mysql Root Password Set

During the default LAMP installation of Ubuntu Gutsy Server, you will be automatically prompted to set the Mysql root user password. This is an extremely convenient feature, that consolidates an entire step. This feature among many other puts Ubuntu server edition at the top of my list for server environments. Although I currently use Debian for my server environment, I may choose to use Ubuntu to deploy a Ruby on Rails server environment.

Mysql Set Root Password

This is a standard requirement of any new Mysql installation. First login: mysql -u root -p Press enter, with no characters entered, when you are prompted for the root password. The password is nothing. Then enter the following into the mysql prompt. Replace temp with your desired password:

SET PASSWORD FOR root@localhost=PASSWORD('temp');