☰

Debian Squeeze/MySQL 错误

tag-icon • tag-icon debian mysql
Debian Squeeze/MySQL 错误

我使用此处接受的答案中的说明在 MySQL 上安装了 lighttpd 和 PHP：

http://raspberrypi.stackexchange.com/questions/1164/how-to-install-lighttpd-with-php

然后我尝试使用此处的说明配置 my.cnf 以允许远程访问 MySQL：

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

当我打字时mysqld start，或者mysqld stop我收到看似永无休止的错误流。贴在这里太长了，我就提几个：

[Note] Plugin 'FEDERATED' is disabled
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: Using the same InnoDB data or log files.
InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
.
.
.
InnoDB: Error in opening ./ibdata1
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: If you tried to add new data files, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your preciious data!
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysqld: Too many arguments (first extra is 'start').
[ERROR] Aborting

我应该怎么办？

答案1

在我看来你已经有mysql守护进程在运行。我没有检查上面的链接，但如果您已经输入了条目/etc/rc.local，或者/etc/rc.d/rc.mysqld您应该知道这些条目用于在启动过程中启动 mysql 服务器。

启动后针对您的主机运行nmap以查看服务是否正在运行。

相关内容