mysql 常用命令

创建用户
CREATE USER 'planet'@'%' IDENTIFIED BY '123456';
CREATE DATABASE surveys DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
grant all on surveys.* to 'planet'@'%'IDENTIFIED BY '123456';
use surveys;


修改密码
use mysql;
UPDATE user SET password=PASSWORD('wsxokn24685') WHERE user='root';
UPDATE user SET password=PASSWORD('123456') WHERE user='planet';
FLUSH PRIVILEGES;


查看当前用户
select user();


root用户下查看所有用户：select * from mysql.user;