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