如何在Fedora 20 上安裝Mysql

標籤：style   color   os   io   for   ar   資料   art   cti   

[[email protected] ~]# 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

完畢！
[[email protected] ~]# systemctl start mysqld.service
[[email protected] ~]# systemctl enable mysqld.service
ln -s ‘/usr/lib/systemd/system/mysqld.service‘ ‘/etc/systemd/system/multi-user.target.wants/mysqld.service‘
[[email protected] ~]# 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 [email protected]=password(‘XXXXXX‘);
Query OK, 0 rows affected (0.00 sec)

mysql> set password for [email protected]=password(‘XXXXXX‘);
Query OK, 0 rows affected (0.00 sec)

mysql> set password for [email protected]‘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
[[email protected] ~]# 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
[[email protected] ~]#

如何在Fedora 20 上安裝Mysql