Mysql

From Wsms

When you do an install of mysql, you should set the root password.

[root@hayes ~]# mysql -u root
...
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('P@ssw0rd');
mysql> SET PASSWORD FOR 'root'@'hayes.sdlinuxguy.com' = PASSWORD('P@ssw0rd');

This is covered in the MySQL_Tutorial.