数据库配置 my.cnf 1[client] 2user=root 3password=111111 4 5[mysqld] 6########basic settings######## 7server-id = 223 8port = 3306 9user = mysql 10# bind_address = 172.16.6.39 11character_set_server=utf8mb4 12skip_name_resolve = 1 13# max_connections = 800 14max_connections = 128 15max_connect_errors = 1000 16datadir =...

创建可以无主机限制的账号 1create USER 'clibing'@'%' IDENTIFIED BY 'ty88yYMQH0udg1pC'; 创建数据库 1CREATE SCHEMA IF NOT EXISTS `clibing` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ; 授权所有数据库权限 1grant all on *.* to 'clibing'@'%'; 撤销授权所有数据库权限 1revoke all on *.* from 'clibing'@'%'; 只授权对clibing数据库的所有权限 1grant all on clibing.*...