- 论坛徽章:
- 1
|
本帖最后由 cenalulu 于 2012-11-16 16:06 编辑
#add by cenalulu: 回答见6楼
刚看书上说,Mysql启动时,如果/etc/my.cnf和命令行选项有相同的参数时,则以命令行选项的参数为准。也就是命令行优先级高与选项文件。
我在/etc/my.cnf中添加了一条user = mysql
而在启动mysqld_safe时,带了--user=wang这个参数,结果mysql服务器没起来,报如下错误。
121104 15:38:41 mysqld_safe mysqld from pid file /usr/local/mysql/pid/mysql.pid ended
121104 15:38:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
121104 15:38:59 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
121104 15:38:59 [Warning] Ignoring user change to 'wang' because the user was set to 'mysql' earlier on the command line
121104 15:38:59 [Note] Plugin 'FEDERATED' is disabled.
121104 15:38:59 InnoDB: Initializing buffer pool, size = 8.0M
121104 15:38:59 InnoDB: Completed initialization of buffer pool
121104 15:38:59 InnoDB: Started; log sequence number 0 38004995
121104 15:38:59 [Note] Event Scheduler: Loaded 0 events
121104 15:38:59 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.60-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
当我不加--user=wang时,可以正常启动。
请问到底是什么问题呢?谢谢 |
|