create
database
vconldb;创建数据库
CREATE USER 'vconlap'@'%' IDENTIFIED BY 'OStem@00';创建数据库用户名vconlap 连接密码OStem@00 不限制连接IP
grant all privileges on vconldb.* to 'vconlap'@'%' identified by 'OStem@00'; 给用户赋权,当然可以自定义权限列表如:
grant select
,
delete
,
update
,
create
,
drop
on
on vconldb.* to 'vconlap'@'%' identified by 'OStem@00';