mysql5.8 设置密码

最新推荐文章于 2023-05-29 10:00:00 发布

zrk526526

最新推荐文章于 2023-05-29 10:00:00 发布

阅读量804

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/weixin_38836909/article/details/105475141

版权

mysql5.8

查看默认密码
cat /var/log/mysqld.log|grep 'temporary password'
查不到，先关闭数据库
1.通过在命令后面加上--user=root 进行强制使用root账号启动。这样是最快的。
cd /etc/init.d
mysqld --user=root
再查看 cat /var/log/mysqld.log|grep 'temporary password'

修改密码，设置新用户授权远程登录
alter user 'root'@'localhost' identified by '1qWwww@2020';
create user 'jamin'@'%' identified by '1qWwww@2020';
grant all privileges on *.* to 'jamin'@'%' with grant option;

ALTER USER 'jamin'@'%' IDENTIFIED BY '1qWwww@2020' PASSWORD EXPIRE NEVER;
ALTER USER 'jamin'@'%' IDENTIFIED WITH mysql_native_password BY '1qWwww@2020';