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]# 更多Fedora相关信息见Fedora 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=5Oracle 左裁剪ltrim（）函数的使用Oracle PGA和SGA区别以及latch和lock的使用场合相关资讯 Fedora 20 Fedora安装MySQL

Fedora 20系统安装及配置（04/22/2015 06:26:21）
ThinkPad E530 Fedora 20 下无线网（10/05/2014 19:12:46）
在Fedora 20上安装图标主题Numix （06/18/2014 09:14:27）

Fedora 20 安装搜狗拼音输入法（01/19/2015 09:02:39）
Fedora 20下解决用户不在 sudoers （06/19/2014 08:18:27）
KDE Frameworks 5和Plasma Next运（05/24/2014 08:21:42）

本文评论查看全部评论（0）