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

MySQL backup and restore

Backup

# mysqldump -u root -p [database_name] > backup.sql

– OR –

# mysqldump -u root -p --all-database > backup.sql

– OR –

# mysqldump -u root -p [database_name] --tables [table_name] > backup.sql

Restore

# mysql -u root -p < backup.sql

– OR –

# mysql -u root -p [database_name] < backup.sql