当前位置:  首页  >  服务器技术  >  Linux/unix  >  Linux系统

Fedora20下MySQL的安装

从Fedora19以后,Fedora将mysql替换成了mariadb。这两个东西虽然同源,但是个人还是喜欢mysql,而且不知道为什么,在Fedora20(64bit)下,安装mariadb我只成功过一次,网上也完全找不到解决办法。(有谁知道请不吝赐教,谢谢*^_^*)下面是Fedora20下面的安装log[root@racheldensintian]#yum-yin
从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=5
吐了个 "CAO" !
扫码关注 PHP1 官方微信号
PHP1.CN | 中国最专业的PHP中文社区 | 凯发国际娱乐 | 凯发国际娱乐下载 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | PHP问答
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved PHP1.CN 第一PHP社区 版权所有