1.进入mysql命令行内
mysql -uroot -p 回车 输入密码
2.修改密码
UPDATE user SET `authentication_string` = PASSWORD('root') where user='root';
3. 刷新权限, 使修改生效
flush privileges;
参考链接: https://www.cnblogs.com/laowenBlog/p/6828573.html
=================
4. 添加用户
命令:CREATE USER 'username'@'host' IDENTIFIED BY 'password';
例子: CREATE USER 'dog'@'localhost' IDENTIFIED BY '123456';
CREATE USER 'dog2'@'localhost' IDENTIFIED BY '';
create user 'pp'@'%' identified by '8888';
5. 授权
命令:GRANT privileges ON databasename.tablename TO 'username'@'host'
PS: privileges - 用户的操作权限,如SELECT , INSERT , UPDATE 等(详细列表见该文最后面).如果要授予所的权限则使用ALL.;databasename - 数据库名,tablename-表名,如果要授予该用户对所有数据库和表的相应操作权限则可用*表示, 如*.*.
例子: GRANT SELECT, INSERT ON mq.* TO 'dog'@'localhost';
6. 刷新权限
同3
参考链接: https://www.cnblogs.com/xujishou/p/6306765.html
==============
重启服务
service mysql restart
停止和开始, 把restart换成stop和start