VPS侦探论坛

 找回密码
 注册
查看: 5874|回复: 2

LNMP0.7添加第二个站点后无法访问Mysql服务器

[复制链接]
发表于 2011-11-19 23:39:09 | 显示全部楼层 |阅读模式

系统:CentOS 5.7 32bit

如题,之前

/home/wwwroot/abc 访问 http://IP/abc 可以访问的。

今天/root/vhost.sh

绑定了 www.xxx.com 到 /home/wwwroot/abc
还有一个 123.xxx.com 到 /home/wwwroot/123

绑定后两个站都开不了,删除 /usr/local/nginx/conf/vhost 下的两个文件 /root/lnmp reload 后,网站还是不能访问。

检查发些mysql 登录不了。。。 不知道是什么错误???

求解!! 谢谢


  1. 111112 21:21:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  2. 111112 21:21:12 [Note] Event Scheduler: Loaded 0 events
  3. 111112 21:21:12 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
  4. Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  5. 111119 20:33:51 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown
  6. 111119 20:33:51 [Note] Event Scheduler: Purging the queue. 0 events
  7. 111119 20:33:51 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
  8. 111119 20:33:51 mysqld_safe mysqld from pid file /usr/local/mysql/var/209.115.236.1.pid ended
  9. 111119 20:33:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  10. /usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
  11. 111119 20:33:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  12. 111119 20:33:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  13. 111119 20:33:52 mysqld_safe mysqld from pid file /usr/local/mysql/var/209.115.236.1.pid ended
  14. 111119 20:53:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  15. /usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
  16. 111119 20:53:25 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  17. 111119 20:53:25 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  18. 111119 20:53:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/209.115.236.1.pid ended
  19. 111119 21:10:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  20. /usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
  21. 111119 21:10:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  22. 111119 21:10:04 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  23. 111119 21:10:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/209.115.236.1.pid ended
  24. 111119 21:25:50 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  25. /usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
  26. 111119 21:25:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  27. 111119 21:25:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  28. 111119 21:25:50 mysqld_safe mysqld from pid file /usr/local/mysql/var/209.115.236.1.pid ended

复制代码
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2011-11-20 17:07:25 | 显示全部楼层


mysql没有安装成功或mysql 数据库里面的表丢失
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2011-11-20 20:00:49 | 显示全部楼层

但之前mysql 都是正常的。。。。

只是绑定域名和开通伪静态后才发生这个问题。

不知道应该如何解救?? 重装mysql ?
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-11-16 02:37 , Processed in 0.025745 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表