Home > Database > Mysql Tutorial > Mysql5.7如何修改root密码_MySQL

Mysql5.7如何修改root密码_MySQL

PHP中文网
Release: 2016-05-27 13:45:32
Original
1272 people have browsed it

版本更新,原来user里的password字段已经变更为authentication_string

版本更新 缘故,好多网上的教程都不适用了,甚至连官网的文档也不是能够顺利操作的。

如果 MySQL 正在运行,首先杀之:


killall -TERM mysqld。
Copy after login


运行


mysqld_safe --skip-grant-tables &
Copy after login


如果此时不想被远程连接:


mysqld_safe --skip-grant-tables --skip-networking &
Copy after login


使用mysql连接server

更改密码:


update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';
Copy after login


*特别提醒注意的一点是,新版的mysql数据库下的user表中已经没有Password字段了

而是将加密后的用户密码存储于authentication_string字段


mysql> flush privileges;
mysql> quit;
Copy after login


修改完毕。重启


killall -TERM mysqld。
mysqld_safe &
Copy after login


然后mysql就可以连接了

但是此时操作似乎功能不完全,还要alter user...


alter user 'root'@'localhost' identified by '123';
Copy after login


网文说酱紫也可以:

set password for 'root'@'localhost'=password('123');
cp mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig --add mysql
Copy after login


以上就是Mysql5.7如何修改root密码_MySQL的内容,更多相关内容请关注PHP中文网(www.php.cn)!



Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template