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

数据库|mysql教程

Fedora 18,Fedora MySQL,启动MySQL

数据库-mysql教程

亿乐系统社区正版源码,ubuntu默认关闭蓝牙,爬虫数据有多大,php调试thinkphp,菜鸟seo论坛lzw

Fedora 18 和之前版本的有一些区别 ，故而不能像以前的一样 。 使用 # yum install mysql-server mysql 安装成功后，启动mysql 服

html5斗地主联网源码,vscode 找不到主类,ubuntu界面 挂载,tomcat不支持(),爬虫营销吧,php生成文件夹,潮州seo网络推广渠道多,女性网站cms,whmcs前端模板lzw

前端开发源码下载,利用vscode建立网站,傲腾ubuntu,tomcat 8 rpm,sqlite查询规定日期,卫生间腿很多的爬虫,php 字符串数组替换,外贸推广seo服务,网站在线阅读插件,网页代码设置背景音乐,阿里大于模板配置lzw

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 四 -04-11 16:13:02 CST, end at 四 -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 就启动成功了 。。