Configuration

How to configure MySQL

By default the root password for MySQL is blank, but it is not safe.

Set the root password by entering the following in terminal.

mysqladmin -u root -p password 'password'

This will set the root password.

Now you can login to the MySQL using the password you have just created.

mysql -u root -p

This will ask you for the root password, just enter the password to access the MySQL console.

Syndicate content