mysql创建远程用户独立数据库的命令 - mysql常见问题

IDENTIFIED BY 后面是密码

CREATE USER 'daohang'@'%' IDENTIFIED BY 'login_88';

GRANT USAGE ON * . * TO 'daohang'@'%' IDENTIFIED BY 'login_88' 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 `daohang` ;

GRANT ALL PRIVILEGES ON `daohang` . * TO 'daohang'@'%';

.....

转载请注明：谷谷点程序 » mysql创建远程用户独立数据库的命令