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');

Leave a Reply