CREATE DATABASE `activity`;
USE mysql;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON activity.* to tlwlmy@localhost IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON activity.* to tlwlmy@'%' IDENTIFIED BY '123456';
FLUSH PRIVILEGES;
二、检查服务器磁盘
查看剩余磁盘
清理数据库bin-log文件
# 查看bin-log
mysql> show master logs;# 将 binlog 文件删除至 mysql-bin.000100 前
mysql> purge master logs to 'mysql-bin.000100';# 将 binlog 文件删除至此日期前
mysql> purge master logs before '2020-01-16 11:00:00';