创建数据库、业务用户
create database xxx character set utf8 collate utf8_bin;
grant all privileges on xxx.* to 'xxx'@'%' identified by 'pass' with grant option;
grant all privileges on xxx.* to 'xxx'@'127.0.0.1' identified by 'pass' with grant option;
grant all privileges on xxx.* to 'xxx'@'localhost' identified by 'pass' with grant option;
grant all privileges on xxx.* to 'xxx'@'hostname' identified by 'pass' with grant option;
grant select on mysql.proc to xxx;
grant show databases on *.* to xxx;
grant all privileges on xxx.* to 'xxx'@'%' identified by 'pass' with grant option;
grant all privileges on xxx.* to 'xxx'@'127.0.0.1' identified by 'pass' with grant option;
grant all privileges on xxx.* to 'xxx'@'localhost' identified by 'pass' with grant option;
grant all privileges on xxx.* to 'xxx'@'hostname' identified by 'pass' with grant option;
grant select on mysql.proc to xxx;
grant show databases on *.* to xxx;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29911917/viewspace-2149555/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
新建表空间、用户及授权
请登录后发表评论
登录
全部评论
