Posts Tagged ‘ 数据库错误

kloxo出现“Could not open database connection.”错误的解决办法

第一种情况:
http://ip:7778/thirdparty/phpMyAdmin/
输入root帐号和密码可以登陆的话,登陆ssh管理
mysql -u root -p
输入密码回车

代码:

mysql> grant all on kloxo.* to kloxo@localhost identified by '{新密码}';
mysql> flush privileges;
mysql> quit

代码:

cat "{新密码}" > /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass
sh /script/restart

—–另外一种情况是
http://ip:7778/thirdparty/phpMyAdmin/ 输入帐号密码登陆不进去的话
登陆ssh

代码:

service mysqld stop

mysqld_safe --skip-grant-tables &
mysql -u root

mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('新密码') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit;

service mysqld start
service httpd restart
service kloxo restart

PS: 有时重启VPS,也有可能自然恢复正常,所以可以试下先重启主机,在看看如果正常了就无需修改!

阅读全文

 
友情链接助孕助孕助孕武汉助孕北京助孕助孕上海助孕捐卵网捐卵网