how to set the initial password for MYSQL

After installed MySQL in your machine, you may meet the below error when you first login

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

This is because the password hasn’t been set for the root user

To resolve the problem.

1.       stop mysql server

service mysql stop

2.       start mysql using safe_mode

/usr/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

3.       login to mysql without password

mysql -u root

4.       update mysql user password

Update user SET Password=PASSWORD('111111') where USER='root';

5.       start mysql as normal and enjoy your mysql trip