MYSQL 一些基础的命令

# 指定主机连接
mysql -u root -h localhost -p

# 创建管理员 ADMINNAME 用户，允许192.168.*.*,内网网段登录
CREATE USER 'ADMINNAME'@'192.168.%' IDENTIFIED BY 'PASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'ADMINNAME'@'192.168.%' WITH GRANT OPTION;
# 刷新权限
FLUSH PRIVILEGES;

# 创建一个 USERNAME 用户允许所有IP链接，并拥有与用户名相同的数据库
CREATE USER 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD';
GRANT USAGE ON *.* TO 'USERNAME'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
CREATE DATABASE IF NOT EXISTS `USERNAME`;
GRANT ALL PRIVILEGES ON `USERNAME`.* TO 'USERNAME'@'%';
# 允许所有与用户名相同的带下划线加后缀的数据库权限。
GRANT ALL PRIVILEGES ON `USERNAME\_%`.* TO 'USERNAME'@'%';