MySQL创建用户的方式: 1. insert into user; 2. create user; 3. grant all privileges on *.* to ‘xxx’@’xxx’ identified by ‘xxxxx’ 演示如下: 查看user表目前存在的用户: select user, host,passowrd from mysql.user; 增加新用户有如下几种方式 insert into mysql.user(user, host, password) values('xxx', 'xxx', password('xxx')); flush privileg