Topic: [MySql求助]为什么每次重起后密码都被重置?

  Print this page

1.[MySql求助]为什么每次重起后密码都被重置? Copy to clipboard
Posted by: jfml
Posted on: 2003-07-07 13:03

我装的是3.23.56

一开始密码是root : public

然后我把密码改为其它的

当时是有效的

但是每次重起后密码又回复到public了

请问这是为何呢

如何改掉呢

谢谢指点

2.Re:[MySql求助]为什么每次重起后密码都被重置? [Re: CrazyJavar] Copy to clipboard
Posted by: samx
Posted on: 2003-07-09 08:41

还是以root身份连接mysql server, 然后更改密码即可。命令:grant all on mysql.* to 'root'@'localhost' identiified by 'youpassword' ;

3.Re:[MySql求助]为什么每次重起后密码都被重置? [Re: CrazyJavar] Copy to clipboard
Posted by: anray
Posted on: 2003-07-14 15:01

你直接修改user表看看:
update user set password=password('your password') where user='your user'


   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923