[MySQL] After installation of MySQL 8

After installation, some things you can do.

Security

# mysql_secure_installation

Change auth_plugin

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword_you_want';

Change default auth_plugin

edit /usr/local/etc/mysql/my.cnf

[mysqld] default-authentication-plugin = mysql_native_password

---

Below is some things about password.

Change password

# mysqladmin -u root -p password

* Reset root password

# /usr/local/etc/rc.d/mysql-server stop 
# mysqld_safe --skip-grant-tables &
# mysqladmin -u root password 
# /usr/local/etc/rc.d/mysql-server restart