求救,mysql问题

inspire5 2013-09-18 09:55:41
启动数据库
[root@MyVPS2393 ~]# /etc/init.d/mysql start
Starting MySQL..................................................................................................... ERROR! The server quit without updating PID file (/usr/local/mysql/var/MyVPS2393.pid).


显示错误文件
[root@MyVPS2393 var]# less MyVPS2393.err
130606 09:00:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130606 9:00:19 InnoDB: The InnoDB memory heap is disabled
130606 9:00:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130606 9:00:19 InnoDB: Compressed tables use zlib 1.2.3
130606 9:00:19 InnoDB: Initializing buffer pool, size = 16.0M
130606 9:00:19 InnoDB: Completed initialization of buffer pool
130606 9:00:19 InnoDB: highest supported file format is Barracuda.
130606 9:00:19 InnoDB: Waiting for the background threads to start
130606 9:00:20 InnoDB: 1.1.8 started; log sequence number 1595675
130606 9:00:20 [Note] Recovering after a crash using mysql-bin
130606 9:00:20 [Note] Starting crash recovery...
130606 9:00:20 [Note] Crash recovery finished.
130606 9:00:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130606 9:00:20 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130606 9:00:20 [Note] Server socket created on IP: '0.0.0.0'.
130606 9:00:20 [Note] Event Scheduler: Loaded 0 events
130606 9:00:20 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.28-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
130606 9:46:09 [Warning] IP address '173.208.202.190' could not be resolved: Name or service not known
130606 12:11:44 [Warning] IP address '121.199.41.41' could not be resolved: Name
MyVPS2393.err
130606 09:00:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130606 9:00:19 InnoDB: The InnoDB memory heap is disabled
130606 9:00:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130606 9:00:19 InnoDB: Compressed tables use zlib 1.2.3
130606 9:00:19 InnoDB: Initializing buffer pool, size = 16.0M
130606 9:00:19 InnoDB: Completed initialization of buffer pool
130606 9:00:19 InnoDB: highest supported file format is Barracuda.
130606 9:00:19 InnoDB: Waiting for the background threads to start
130606 9:00:20 InnoDB: 1.1.8 started; log sequence number 1595675
130606 9:00:20 [Note] Recovering after a crash using mysql-bin
130606 9:00:20 [Note] Starting crash recovery...
130606 9:00:20 [Note] Crash recovery finished.
130606 9:00:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130606 9:00:20 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130606 9:00:20 [Note] Server socket created on IP: '0.0.0.0'.
130606 9:00:20 [Note] Event Scheduler: Loaded 0 events
130606 9:00:20 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.28-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
130606 9:46:09 [Warning] IP address '173.208.202.190' could not be resolved: Name or service not known
130606 12:11:44 [Warning] IP address '121.199.41.41' could not be resolved: Name or service not known
130606 12:19:19 [Warning] IP address '222.66.154.138' could not be resolved: Name or service not known
130606 16:28:41 [Warning] IP address '111.2.100.197' could not be resolved: Temporary failure in name resolution
130607 11:23:15 [Warning] IP address '218.61.104.25' could not be resolved: Name or service not known
130607 21:22:38 [Warning] IP address '27.36.163.121' could not be resolved: Name or service not known
130608 23:41:12 [Warning] IP address '121.199.11.115' could not be resolved: Name or service not known
130609 9:37:15 [Warning] IP address '173.208.249.117' could not be resolved: Name or service not known
130609 19:48:45 [Warning] IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:46 [Warning] IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:46 [Warning] IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
...全文
144 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
rucypli 2013-09-18
  • 打赏
  • 举报
回复
mysql.cnf中加入skip-name-resolve
inspire5 2013-09-18
  • 打赏
  • 举报
回复
引用 1 楼 rucypli 的回复:
mysql.cnf中加入skip-name-resolve
加了,但是问题依旧。

56,681

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧