1. 连接本地数据库

   mysql -P 55501 -h 127.0.0.1 -u root -p

2. 新建数据库和用户，并赋于用户管理数据库的权限

   CREATE DATABASE `databasename`;

   CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

   GRANT ALL PRIVILEGES ON `databasename` . * TO 'username'@'localhost';

   GRANT SELECT ON mysql.time_zone_name TO username@localhost;

   flush privileges;

3. 修改密码

   UPDATE user SET authentication_string=PASSWORD('123456') WHERE user='root';

4. 清除mysql操作记录

   echo "" > /root/.mysql_history

5. 备份所有数据库:

   mysqldump --all-databases --user=root --password --master-data > backupdatabase.sql

   注：需要在my.cnf里面开启log_bin=mysql-bin

6. 给数据库用户授权

   GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY '123456' WITH GRANT OPTION;
   

除特别注明外，本站所有文章均为奇妙伞原创，转载请注明出处来自https://www.qm3.com.cn/post/198.html