MOOMAU 2.0

Tag: database

  • [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

  • [MySQL] 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