Question

linux中mysql安装完mysql启动时，报如下错误Timeout error occurred trying to start MySQL Daemon.

这是日志
110920 16:46:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110920 16:46:21 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
110920 16:46:21 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110920 16:46:21 InnoDB: The InnoDB memory heap is disabled
110920 16:46:21 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
110920 16:46:21 InnoDB: Compressed tables use zlib 1.2.3
110920 16:46:21 InnoDB: Using Linux native AIO
110920 16:46:21 InnoDB: Initializing buffer pool, size = 128.0M
110920 16:46:22 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5042176 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
110920 16:46:22 [ERROR] Plugin 'InnoDB' init function returned error.
110920 16:46:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110920 16:46:22 [ERROR] Unknown/unsupported storage engine: InnoDB
110920 16:46:22 [ERROR] Aborting
110920 16:46:22 [Note] /usr/sbin/mysqld: Shutdown complete
110920 16:46:22 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended

Answer 1

110920 16:46:21 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

解决办法 在运行初始化权限表的时候使用增加参数--datadir ，命令格式为：
shell> scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/var
这样问题就解决了。

Answer 2

＃addgroup mysql
＃useradd -g mysql mysql
建立mysql组 添加mysql用户到 mysql组
--------
＃chmod +x /etc/init.d/mysqld
#/etc/init.d/mysqld start
这个应该知道吧
----------
chown mysql:mysql （这里需要一个目标文件），如：chown mysql:mysql /opt/mysql

------------
1、看一下/etc中有没有 my.cnf，如果没有的话，在mysql的安装目录下的 support-files目录中 选一个合适的my-xxxx.cnf文件 复制过去。
2、如果已经有这个文件的话，多半是权限问题了。试试用root启动mysql

Answer 3

%%什么啊