数据库创建用户和数据库

mysql

--创建khywwx用户，%代表任何主机都可以连接

CREATE USER 'khywwx'@'%' IDENTIFIED BY '@dHN&Typzn^ZMG';

--授权wx的表给客户

GRANT ALL PRIVILEGES ON wx.* TO 'khywwx'@'%';

 

oracle

创建密码为password的username命令

CREATE USER username IDENTIFIED BY password

授权用户

GRANT CONNECT, RESOURCE TO username;