创建数据库、业务用户

发布时间：2020-08-08 11:06:31 作者：laojiangjiji
阅读：129

亿速云数据库,弹性扩容,低至0.3元/天! 查看>>

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;

亿速云「云数据库 MySQL」免部署即开即用，比自行安装部署数据库高出1倍以上的性能，双节点冗余防止单节点故障，数据自动定期备份随时恢复。点击查看>>

创建数据库、业务用户

相关阅读