提示安装mysql成功，启动失败

oncecat

系统是   debian6

hnbbs

Mysql 安装成功，继续安装LuNamp1.0
Mysql was successfully installed! Continue...

-e



已耗时：42 秒钟
Runtime: 42 秒钟

110330 02:11:26 mysqld_safe Logging to '/home/mysql_data/215674.err'.
110330 02:11:26 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
110330 02:11:26 mysqld_safe mysqld from pid file /home/mysql_data/215674.pid ended

MySQL 启动失败！
MySQL was started failed.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

MySQL数据导入不成功，可能是数据库没启动，或者是MySQL没安装成功，请重装一次试试！
Mysql data was not imported！

hnbbs

同样的问题，在VPS的debian6上，32和64位都是一样的错误，环境没问题。

hnbbs

mysql日志为：

110330 02:11:22 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
110330  2:11:22 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external
-locking' instead.
110330  2:11:22 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110330  2:11:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/local/mysql/libexec/mysqld: Can't create/write to file '/tmp/ibhahEeu' (Errcode: 13)
110330  2:11:22  InnoDB: Error: unable to create temporary file; errno: 13
110330  2:11:22 [ERROR] Plugin 'InnoDB' init function returned error.
110330  2:11:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110330  2:11:22 [ERROR] Can't start server : Bind on unix socket: Permission denied
110330  2:11:22 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
110330  2:11:22 [ERROR] Aborting

110330  2:11:22 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110330 02:11:22 mysqld_safe mysqld from pid file /home/mysql_data/215674.pid ended
110330 02:11:26 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
110330  2:11:26 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external
-locking' instead.
110330  2:11:26 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110330  2:11:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/local/mysql/libexec/mysqld: Can't create/write to file '/tmp/ibDA6koU' (Errcode: 13)
110330  2:11:26  InnoDB: Error: unable to create temporary file; errno: 13
110330  2:11:26 [ERROR] Plugin 'InnoDB' init function returned error.
110330  2:11:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110330  2:11:26 [ERROR] Can't start server : Bind on unix socket: Permission denied
110330  2:11:26 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
110330  2:11:26 [ERROR] Aborting

110330  2:11:26 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110330 02:11:26 mysqld_safe mysqld from pid file /home/mysql_data/215674.pid ended
110330 02:11:29 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
110330  2:11:29 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external
-locking' instead.
110330  2:11:29 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110330  2:11:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/local/mysql/libexec/mysqld: Can't create/write to file '/tmp/ib4TBvM1' (Errcode: 13)
110330  2:11:29  InnoDB: Error: unable to create temporary file; errno: 13
110330  2:11:29 [ERROR] Plugin 'InnoDB' init function returned error.
110330  2:11:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110330  2:11:29 [ERROR] Can't start server : Bind on unix socket: Permission denied
110330  2:11:29 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
110330  2:11:29 [ERROR] Aborting

110330  2:11:29 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110330 02:11:29 mysqld_safe mysqld from pid file /home/mysql_data/215674.pid ended

爱洞特漏

在/etc/my.cnf的mysqld部分，加入
skip-innodb
然后再重启mysql

hnbbs

问题还是解决不了啊，现在把编译选项中去掉innodb再重新编译次看看如何。

问题的原因是什么？第一次使用vps来安装啊。

hnbbs

去掉编译选项后问题依旧啊，下面是日志：

110330 03:59:57 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
110330  3:59:57 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external
-locking' instead.
110330  3:59:57 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110330  3:59:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110330  3:59:57 [ERROR] Can't start server : Bind on unix socket: Permission denied
110330  3:59:57 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
110330  3:59:57 [ERROR] Aborting

110330  3:59:57 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110330 03:59:57 mysqld_safe mysqld from pid file /home/mysql_data/215674.pid ended
110330 04:00:02 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
110330  4:00:02 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external
-locking' instead.
110330  4:00:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110330  4:00:02 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110330  4:00:02 [ERROR] Can't start server : Bind on unix socket: Permission denied
110330  4:00:02 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
110330  4:00:02 [ERROR] Aborting

110330  4:00:02 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110330 04:00:02 mysqld_safe mysqld from pid file /home/mysql_data/215674.pid ended
110330 04:00:05 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
110330  4:00:05 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external
-locking' instead.
110330  4:00:05 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110330  4:00:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110330  4:00:05 [ERROR] Can't start server : Bind on unix socket: Permission denied
110330  4:00:05 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
110330  4:00:05 [ERROR] Aborting

110330  4:00:05 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110330 04:00:05 mysqld_safe mysqld from pid file /home/mysql_data/215674.pid ended

爱洞特漏

把VPS的IP和密码给我看一下

dg123654

是什么原因》





__________________
不锈钢反应釜
Watches

hnbbs

经过洞主的排查：在我的VPS的debian6下，mysql的启动用户必须是root，否则不能正常启动，已转到centos了。