Fedora 18 安装完MySQL 无法启动问题
时间:2015-03-24 12:58 来源:linux.it.net.cn 作者:IT
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: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- Documentation: http://www.freedesktop.org/wiki/Software/systemd/catalog/7d4958e842da4a758f6c1cdc7b36dcc5
--
-- 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: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- Documentation: http://www.freedesktop.org/wiki/Software/systemd/catalog/be02cf6855d2428ba40df7e9d022f03d
--
-- 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 就启动成功了 。。
(责任编辑：IT)
| 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: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- Documentation: http://www.freedesktop.org/wiki/Software/systemd/catalog/7d4958e842da4a758f6c1cdc7b36dcc5 -- -- 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: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- Documentation: http://www.freedesktop.org/wiki/Software/systemd/catalog/be02cf6855d2428ba40df7e9d022f03d -- -- 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 就启动成功了 。。 (责任编辑：IT) |