数据库备份与恢复

备份

mysqldump -u username -p database_name > /path/to/backup.sql

导入

mysql -u username -p database_name < /path/to/backup.sql

# 使用pv显示进度
sudo apt-get install pv
pv /path/to/backup.sql | mysql -u username -p database_name

用户

$ mysql -u root -p
$ mysql > use mysql;

# 创建一个账户
$ mysql > CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

# 修改密码
$ mysql > ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

# 授予所有数据库和表的读写权限：
$ mysql > GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';

# 授予某个数据库的全部权限：
$ mysql > GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';

# 授予某个数据库的只读权限：
$ mysql > GRANT SELECT  ON database.* TO 'username'@'localhost';

# 授予 PROCESS 权限
$ mysql > GRANT PROCESS ON *.* TO 'username'@'localhost';

$ mysql > FLUSH PRIVILEGES;