官网下载mysql-5.7.9-winx64.zip
注意:牢记上面MySQL自动生成的密码
mysql -u root -p password
创建用户并授权
--创建用户并授权
命令:CREATE USER 'username'@'host' IDENTIFIED BY 'password';
例:
CREATE USER 'dog'@'localhost' IDENTIFIED BY '123456';
CREATE USER 'pig'@'192.168.1.101' IDENDIFIED BY '123456';
CREATE USER 'pig'@'%' IDENTIFIED BY '123456';
CREATE USER 'pig'@'%' IDENTIFIED BY '';
CREATE USER 'pig'@'%';
授权root某IP访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION;
flush privileges;
--设置与更改用户密码
设置其他用户密码:SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');
设置当前用户密码:SET PASSWORD = PASSWORD("newpassword");
--删除用户
删除命令: DROP USER 'username'@'host';