Change New Installed Mysql Root PassWord

When you Install Mysql sudeently. You should dont know root pass. You need change your root pass:
At first time login mysql, you don’t need password.

Login shell:

mysql -u root

Change Root Pass

  • As of MySQL 5.7.6, use ALTER USER:
    mysql> ALTER USER user IDENTIFIED BY ‘new_password’;

  • Before 5.7.6, use SET PASSWORD:
    mysql> SET PASSWORD FOR user = PASSWORD(‘new_password’);