dre4m 发表于 2011-2-21 18:25:01

mysql密码忘了

请问有什么快捷的解决方法，我装完lnmp，然后进入phpmyadmin，用户写root，密码不知道该写什么了，好像其他密码都不对，请问有重置的方法吗？

licess 发表于 2011-2-21 19:58:38

回复 1# 的帖子

执行如下命令：
wget http://soft.vpser.net/lnmp/ext/reset-mysql-root-password.phps
php reset-mysql-root-password.phps 新密码

liyucmh 发表于 2013-9-25 13:12:04

原帖由 licess 于 2011-2-21 19:58 发表 https://bbs.vpser.net/images/common/back.gif
执行如下命令：
wget http://soft.vpser.net/lnmp/ext/reset-mysql-root-password.phps
php reset-mysql-root-password.phps 新密码
军哥, 我用了这样去重置忘了的密码 系统是ubuntu 还是无法登陆网页的phpmyind,cookies也清空了.
执行到最后有提示成功, 中间有警告
root@ubuntu:~# php reset-mysql-root-password.phps 123456aa
Stoping mysql
PHP Warning:shell_exec() has been disabled for security reasons in /root/reset-mysql-root-password.phps on line 13
starting with skip grant tables
PHP Warning:shell_exec() has been disabled for security reasons in /root/reset-mysql-root-password.phps on line 15
using mysql to flush privileges and reset password
PHP Notice:Undefined variable: return in /root/reset-mysql-root-password.phps on line 19
PHP Warning:system() has been disabled for security reasons in /root/reset-mysql-root-password.phps on line 19
PHP Notice:Undefined variable: return in /root/reset-mysql-root-password.phps on line 21
Password reset succesfully. Now killing mysqld softly
PHP Warning:shell_exec() has been disabled for security reasons in /root/reset-mysql-root-password.phps on line 28
sleeping
PHP Warning:shell_exec() has been disabled for security reasons in /root/reset-mysql-root-password.phps on line 30
restarting the actual mysql service
PHP Warning:system() has been disabled for security reasons in /root/reset-mysql-root-password.phps on line 32
Password successfully reset to "123456aa"

请问是哪里操作错误了呢

licess 发表于 2013-9-25 15:43:18

回复 3# 的帖子

php的system函数被禁用，使用http://lnmp.org/faq.html 这里面的新方法和脚本
页: [1]
查看完整版本: mysql密码忘了