y**e 发帖数: 13 | 1 I have to charge one exist mysql sever, but my previous administrator didn't
leave any password before he left. I try to figure out all the administration
password for mysql. But don't know how to get it.
I search online, the password suppose store in the table mysql.user , and
password put it in my.cnf. But I can't find it.
Is anybody know how to get the password?
This is not hacker, it's really need it.
Thank you very much. | b*e 发帖数: 3845 | 2 password is encrypted. one-way function, you cannot get it, period.
【在 y**e 的大作中提到】 : I have to charge one exist mysql sever, but my previous administrator didn't : leave any password before he left. I try to figure out all the administration : password for mysql. But don't know how to get it. : I search online, the password suppose store in the table mysql.user , and : password put it in my.cnf. But I can't find it. : Is anybody know how to get the password? : This is not hacker, it's really need it. : Thank you very much.
| y**e 发帖数: 13 | 3 How can I get the system password on database,
I have all the privillges on the server which mysql sit in, but don't have any
password for mysql. How can I get in?? anybody help me?
didn't
administration
【在 b*e 的大作中提到】 : password is encrypted. one-way function, you cannot get it, period.
| p**i 发帖数: 688 | 4 start mysqld with --skip-grant-tables
after you modify the password, restart mysqld
【在 y**e 的大作中提到】 : How can I get the system password on database, : I have all the privillges on the server which mysql sit in, but don't have any : password for mysql. How can I get in?? anybody help me? : : didn't : administration
| t********e 发帖数: 1 | 5 that is the right answer. do that as root.
any
【在 p**i 的大作中提到】 : start mysqld with --skip-grant-tables : after you modify the password, restart mysqld
| y**e 发帖数: 13 | 6 I got the password by doing it.
Thank you very much.
have
【在 t********e 的大作中提到】 : that is the right answer. do that as root. : : any
|
|