用户管理

MySQL8.0创建用户和权限控制

--　用户管理
CREATE USER 'zhangsan'@'localhost' IDENTIFIED BY '123';
SHOW GRANTS FOR 'zhangsan'@'localhost';
GRANT SELECT,INSERT ON *.* TO 'zhangsan'@'localhost';
REVOKE INSERT ON *.* FROM 'zhangsan'@'localhost';
SET PASSWORD FOR 'zhangsan'@'localhost' = PASSWORD('123456');
DROP USER 'zhangsan'@'localhost';

备份导入导出迁移

• MySQL借助DBeaver工具数据导入导出
• MySQL定时备份数据库（全库备份）
• MySql数据库备份的几种方式

  Table Status

1. 输出MySQL数据库管理系统的性能及统计信息

   SHOW TABLE STATUS FROM W3CSCHOOL;
   SHOW TABLE STATUS LIKE 'book&';