Install MySQL in CentOS and change Passoword

Install mysqlinstalling MySQL

• wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
• Md5sum mysql57-community-release-el7-9.noarch.rpm
• RPM-IVH mysql57-community-release-el7-9.noarch.rpm
• Yum Install Mysql-server

Starting MySQL

• Systemctl Start mysqld
• Systemctl Status Mysqld

• grep ' temporary password '/var/log/mysqld.log

  2016-12-01T00:22:31.416107Z 1 [Note] A temporary password is generated for [email protected]: mqRfBU_3Xk>r

Change Password

• Stop mysqld

  ps -ef|grep -i mysqlsystemctl stop mysqld

• Edit/etc/my.conf

Vim/etc/my.cnf

[mysqld]skip-grant-tables

• Change Password

  # mysql -u rootmysql> use mysql;mysql> update mysql.user set authentication_string=password(‘123‘) where user=‘root‘;mysql> flush privileges;mysql> exit

• Comment Skip-grant-tables in/etc/my.cnf

• Restart MySQL

  systemctl stop mysqldsystemctl start mysqld

Install MySQL in CentOS and change Passoword