fedora 20自带mysql_fedora 20 mysql 的安装

从fedora 19以后，fedora将mysql 替换成了mariadb。这两个东西虽然同源，但是个人还是喜欢mysql，而且不知道为什么，在fedora 20(64bit)下，安装mariadb我只成功过一次，网上也完全找不到解决办法。(有谁知道请不吝赐教，谢谢*^_^*)

下面是fedora 20 下面的安装log

[root@rachel densintian]# yum -y install community-mysql-server #安装数据库

已加载插件：langpacks, refresh-packagekit

google-chrome                                                               3/3

正在解决依赖关系

There are unfinished transactions remaining. You might consider running yum-complete-transaction, or "yum-complete-transaction --cleanup-only" and "yum history redo last", first to finish them. If those don't work you'll have to try removing/installing packages by hand (maybe package-cleanup can help).

--> 正在检查事务

---> 软件包 community-mysql-server.x86_64.0.5.5.35-1.fc20 将被 安装

--> 正在处理依赖关系 community-mysql-common(x86-64) = 5.5.35-1.fc20，它被软件包 community-mysql-server-5.5.35-1.fc20.x86_64 需要

--> 正在处理依赖关系 mysql(x86-64)，它被软件包 community-mysql-server-5.5.35-1.fc20.x86_64 需要

--> 正在检查事务

---> 软件包 community-mysql.x86_64.0.5.5.35-1.fc20 将被 安装

---> 软件包 community-mysql-common.x86_64.0.5.5.35-1.fc20 将被 安装

--> 解决依赖关系完成

依赖关系解决

================================================================================

Package                     架构        版本                源            大小

================================================================================

正在安装:

community-mysql-server      x86_64      5.5.35-1.fc20       updates      8.8 M

为依赖而安装:

community-mysql             x86_64      5.5.35-1.fc20       updates      4.9 M

community-mysql-common      x86_64      5.5.35-1.fc20       updates      208 k

事务概要

================================================================================

安装  1 软件包 (+2 依赖软件包)

总下载量：14 M

安装大小：78 M

Downloading packages:

(1/3): community-mysql-5.5.35-1.fc20.x86_64.rpm            | 4.9 MB   00:04

(2/3): community-mysql-common-5.5.35-1.fc20.x86_64.rpm     | 208 kB   00:00

(3/3): community-mysql-server-5.5.35-1.fc20.x86_64.rpm     | 8.8 MB   00:03

--------------------------------------------------------------------------------

总计                                               1.4 MB/s |  14 MB  00:09

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

正在安装    : community-mysql-common-5.5.35-1.fc20.x86_64                 1/3

正在安装    : community-mysql-5.5.35-1.fc20.x86_64                        2/3

正在安装    : community-mysql-server-5.5.35-1.fc20.x86_64                 3/3

验证中      : community-mysql-5.5.35-1.fc20.x86_64                        1/3

验证中      : community-mysql-server-5.5.35-1.fc20.x86_64                 2/3

验证中      : community-mysql-common-5.5.35-1.fc20.x86_64                 3/3

已安装:

community-mysql-server.x86_64 0:5.5.35-1.fc20

作为依赖被安装:

community-mysql.x86_64 0:5.5.35-1.fc20

community-mysql-common.x86_64 0:5.5.35-1.fc20

完毕！

[root@rachel densintian]# systemctl start mysqld.service

[root@rachel densintian]# systemctl enable mysqld.service

ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'

[root@rachel densintian]# mysql -u root  #以root登陆数据库

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.5.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select user, host, password from mysql.user;   #user列表

+------+-----------+----------+

| user | host      | password |

+------+-----------+----------+

| root | localhost |          |

| root | rachel    |          |

| root | 127.0.0.1 |          |

| root | ::1       |          |

|      | localhost |          |

|      | rachel    |          |

+------+-----------+----------+

6 rows in set (0.00 sec)

mysql> delete from mysql.user where user=''; #删除空user

Query OK, 2 rows affected (0.00 sec)

mysql> delete from mysql.user where user='root' and host='::1'; #删除IPv6用户(如果不用的话)

Query OK, 1 row affected (0.00 sec)

mysql> select user, host, password from mysql.user;

+------+-----------+----------+

| user | host      | password |

+------+-----------+----------+

| root | localhost |          |

| root | rachel    |          |

| root | 127.0.0.1 |          |

+------+-----------+----------+

3 rows in set (0.00 sec)

# 设定密码

mysql> set password for root@localhost=password('XXXXXX');

Query OK, 0 rows affected (0.00 sec)

mysql> set password for root@rachel=password('XXXXXX');

Query OK, 0 rows affected (0.00 sec)

mysql> set password for root@'127.0.0.1'=password('XXXXXXX');

Query OK, 0 rows affected (0.00 sec)

#再次列密码

mysql> select user, host, password from mysql.user;

+------+-----------+-------------------------------------------+

| user | host      | password                                  |

+------+-----------+-------------------------------------------+

| root | localhost | *C7E2F6338326EDC0AXXXXXXXXXXXXXXXXXXXXXXX |

| root | rachel    | *C7E2F6338326EDC0AXXXXXXXXXXXXXXXXXXXXXXX |

| root | 127.0.0.1 | *C7E2F6338326EDC0AXXXXXXXXXXXXXXXXXXXXXXX |

+------+-----------+-------------------------------------------+

3 rows in set (0.00 sec)

mysql> exit

Bye

[root@rachel densintian]# mysql -u root -p #再次登录

Enter password:                            #输入刚才的密码

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.5.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit

Bye

[root@rachel densintian]#