mysql刚装好后的一顿操作

mysql装好后root@localhost的密码在安装信息里，登陆后

1.修改root密码的两种方式

UPDATE mysql.user 
SET password = PASSWORD('newpass')
WHERE user = 'root' AND  host = 'localhost';


alter user 'root'@'localhost' identified by 'newpass';

2.创建库，创建用户，授权

create database test;
CREATE USER 'video_adver_r'@'%' IDENTIFIED BY 'pass1';
CREATE USER 'video_adver_w'@'%' IDENTIFIED BY 'pass2';

GRANT select ON db.* TO 'video_r'@'%'
GRANT all ON test.* TO 'video_w'@'%'
flush privileges;