重庆分公司,新征程启航

为企业提供网站建设、域名注册、服务器等服务

创建数据库、业务用户

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;

标题名称:创建数据库、业务用户
URL分享:http://cqcxhl.com/article/jhehch.html

其他资讯

在线咨询
服务热线
服务热线:028-86922220
TOP