您好,欢迎访问一九零五行业门户网

Fedora 18 安装完MySQL 无法启动问题

fedora 18 和之前版本的有一些区别 ,故而不能像以前的一样 。 使用 # yum install mysql-server mysql 安装成功后,启动mysql 服
fedora 18 和之前版本的有一些区别 ,故而不能像以前的一样 。
使用
# yum install mysql-server mysql
安装成功后,启动mysql 服务,使用
# systemctl start mysqld.service
可是 会有如下问题job for mysqld.service failed. see 'systemctl status mysqld.service' and 'journalctl -xn' for details.
使用
# journalctl -xn ,提示
-- logs begin at 四 2013-04-11 16:13:02 cst, end at 四 2013-04-11 22:07:06 cst. --
4月 11 22:05:47 localhost.localdomain dbus-daemon[654]: dbus[654]: [system] rejected send message, 2 matched rules; type=method_return, sender=:1.0
4月 11 22:05:47 localhost.localdomain dbus[654]: [system] rejected send message, 2 matched rules; type=method_return, sender=:1.0 (uid=0 pid=648 c
4月 11 22:06:13 localhost.localdomain dbus-daemon[654]: ** message: no devices in use, exit
4月 11 22:07:03 localhost.localdomain systemd[1]: starting mysql database server...
-- subject: unit mysqld.service has begun with start-up
-- defined-by: systemd
-- support:
-- documentation:
--
-- unit mysqld.service has begun starting up.
4月 11 22:07:03 localhost.localdomain mysqld_safe[7422]: 130411 22:07:03 mysqld_safe logging to '/var/log/mysqld.log'.
4月 11 22:07:04 localhost.localdomain mysqld_safe[7422]: 130411 22:07:04 mysqld_safe starting mysqld daemon with databases from /var/lib/mysql
4月 11 22:07:06 localhost.localdomain mysqld_safe[7422]: 130411 22:07:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
4月 11 22:07:06 localhost.localdomain systemd[1]: mysqld.service: control process exited, code=exited status=1
4月 11 22:07:06 localhost.localdomain systemd[1]: failed to start mysql database server.
-- subject: unit mysqld.service has failed
-- defined-by: systemd
-- support:
-- documentation:
--
-- unit mysqld.service has failed.
--
-- the result is failed.
4月 11 22:07:06 localhost.localdomain systemd[1]: unit mysqld.service entered failed state
查看 /var/log/mysqld.log  内容如下
[root@localhost log]# more mysqld.log
130413 13:45:12 mysqld_safe starting mysqld daemon with databases from /var/lib/
mysql
130413 13:45:12 [note] plugin 'federated' is disabled.
/usr/libexec/mysqld: can't find file: './mysql/plugin.frm' (errno: 13)
130413 13:45:12 [error] can't open the mysql.plugin table. please run mysql_upgr
ade to create it.
130413 13:45:12 innodb: the innodb memory heap is disabled
130413 13:45:12 innodb: mutexes and rw_locks use gcc atomic builtins
130413 13:45:12 innodb: compressed tables use zlib 1.2.7
130413 13:45:12 innodb: using linux native aio
130413 13:45:12 innodb: initializing buffer pool, size = 128.0m
130413 13:45:12 innodb: completed initialization of buffer pool
130413 13:45:12 innodb: highest supported file format is barracuda.
130413 13:45:12 innodb: waiting for the background threads to start
130413 13:45:13 innodb: 5.5.30 started; log sequence number 1595675
130413 13:45:13 [note] server hostname (bind-address): '0.0.0.0'; port: 3306
130413 13:45:13 [note] - '0.0.0.0' resolves to '0.0.0.0';
130413 13:45:13 [note] server socket created on ip: '0.0.0.0'.
130413 13:45:13 [error] /usr/libexec/mysqld: can't find file: './mysql/host.frm'
(errno: 13)
130413 13:45:13 [error] fatal error: can't open and lock privilege tables: can't
find file: './mysql/host.frm' (errno: 13)
130413 13:45:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende
d
130413 13:48:32 mysqld_safe starting mysqld daemon with databases from /var/lib/
mysql
130413 13:48:32 [note] plugin 'federated' is disabled.
/usr/libexec/mysqld: can't find file: './mysql/plugin.frm' (errno: 13)
130413 13:48:32 [error] can't open the mysql.plugin table. please run mysql_upgr
ade to create it.
130413 13:48:32 innodb: the innodb memory heap is disabled
130413 13:48:32 innodb: mutexes and rw_locks use gcc atomic builtins
130413 13:48:32 innodb: compressed tables use zlib 1.2.7
130413 13:48:32 innodb: using linux native aio
130413 13:48:32 innodb: initializing buffer pool, size = 128.0m
130413 13:48:32 innodb: completed initialization of buffer pool
130413 13:48:32 innodb: highest supported file format is barracuda.
130413 13:48:32 innodb: waiting for the background threads to start
130413 13:48:33 innodb: 5.5.30 started; log sequence number 1595675
130413 13:48:33 [note] server hostname (bind-address): '0.0.0.0'; port: 3306
130413 13:48:33 [note] - '0.0.0.0' resolves to '0.0.0.0';
130413 13:48:33 [note] server socket created on ip: '0.0.0.0'.
130413 13:48:33 [error] /usr/libexec/mysqld: can't find file: './mysql/host.frm'
(errno: 13)
130413 13:48:33 [error] fatal error: can't open and lock privilege tables: can't
find file: './mysql/host.frm' (errno: 13)
130413 13:48:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende
d
这个说明是权限问题,之后 执行
# cd /var/lib/mysql
# chown mysql.mysql -r *
# service mysqld start
这个时候,,mysql 就启动成功了 。。
其它类似信息

推荐信息