mysql修改密码起步生效
- WBOYOriginal
- 2016-06-07 16:27:011217browse
mysql修改密码启动生效 需求： 修改mysql的用户名密码然后生效 实现： 1.修改操作： update mysql.user set password=PASSWORD('hive123') where user='hive'; ? 把hive的用户密码修改为hive123 2.生效刷新操作： flush privileges ? ps：好多人忘记第二步骤
mysql修改密码启动生效需求：
修改mysql的用户名密码然后生效
实现：
1.修改操作：
update mysql.user set password=PASSWORD('hive123') where user='hive';
?
把hive的用户密码修改为hive123
2.生效刷新操作：
flush privileges
?
ps：好多人忘记第二步骤了，因此修改后不生效
Statement：
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
Previous article：mysql-触发器Next article：执行mysqldump出错