Tag: database
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