VPS侦探论坛

标题: mysql密码忘了 [打印本页]

作者: dre4m 时间: 2011-2-21 18:25
标题: mysql密码忘了
请问有什么快捷的解决方法，我装完lnmp，然后进入phpmyadmin，用户写root，密码不知道该写什么了，好像其他密码都不对，请问有重置的方法吗？

作者: licess 时间: 2011-2-21 19:58
标题: 回复 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

原帖由 licess 于 2011-2-21 19:58 发表
执行如下命令：
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
标题: 回复 3# 的帖子
php的system函数被禁用，使用http://lnmp.org/faq.html 这里面的新方法和脚本

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)