我无法启动 MYSQL。
我在 WEBMIN 的主 mysql 配置中更改了一个参数:
SKIP LOCKING OF TABLE FILES?... the original value was "NO", and I changed to "YES"
这是日志文件:
131026 1:12:27 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
131026 1:12:27 [Note] Plugin 'FEDERATED' is disabled.
131026 1:12:27 InnoDB: The InnoDB memory heap is disabled
131026 1:12:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131026 1:12:27 InnoDB: Compressed tables use zlib 1.2.3.4
131026 1:12:27 InnoDB: Initializing buffer pool, size = 128.0M
131026 1:12:27 InnoDB: Completed initialization of buffer pool
131026 1:12:27 InnoDB: highest supported file format is Barracuda.
131026 1:12:27 InnoDB: Waiting for the background threads to start
131026 1:12:28 InnoDB: 5.5.34 started; log sequence number 9992525
131026 1:12:28 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
131026 1:12:28 [ERROR] Aborting
131026 1:12:28 InnoDB: Starting shutdown...
131026 1:12:29 InnoDB: Shutdown completed; log sequence number 9992525
131026 1:12:29 [Note] /usr/sbin/mysqld: Shutdown complete
问题出在 [ERROR] /usr/sbin/mysqld: 未知选项‘--skip-locking’。
所以,我的文件“my.cnf”是好的,因为它说的是:
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
请帮助我重新启动 mysql。
非常感谢您付出的时间和帮助
答案1
看起来您的 MySQL 不支持此标志。您是否尝试过在 webmin 中改回此选项?如果没有帮助,请尝试查看 /etc/init.d/mysqld 和 /etc/default/mysqld(我不确定文件名)。在那里查找守护进程的参数。