Setting the Root Password

As you probably noticed when you logged in just now, you had to supply a username—root—but not a password. The initial installation of MySQL has no root password set. It's really important to set this password for obvious security reasons. In the MySQL monitor, type the following:

set password for root@localhost=password('your password');

Obviously, you should replace your password with whatever you would like the root password to be.

Log out (\q) and then log back in. This time, you need to log in like this:

mysql -u root -p

MySQL then prompts you for your password. The -u means username, and the -p means log in with password.