After Fedora 19, Fedora replaces mysql with mariadb. Although these two things are the same, I still like mysql, and I don't know why. In Fedora 20 (64bit), I only installed mariadb once, no solution can be found on the Internet. (If anyone knows, please kindly advise. Thank you * ^_^ *)
Below is the Installation log under Fedora 20
[Root @ rachel densintian] # yum-y install community-mysql-server # install Database
Loaded plug-ins: langpacks, refresh-packagekit
Google-chrome & nbsp; & nbsp; & nbsp; 3/3
Resolving dependency
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 ).
--> Checking the transaction
---> The package community-mysql-server.x86_64.0.5.5.35-1.fc20 will be installed
--> Is processing dependency community-mysql-common (x86-64) = 5.5.35-1. fc20, which is required by the software package community-mysql-server-5.5.35-1.fc20.x86_64
--> Processing dependency mysql (x86-64), which is required by the software package community-mysql-server-5.5.35-1.fc20.x86_64
--> Checking the transaction
---> The package community-mysql.x86_64.0.5.5.35-1.fc20 will be installed
---> The package community-mysql-common.x86_64.0.5.5.35-1.fc20 will be installed
--> Dependency resolved
Dependency Solution
========================================================== ==========================================================
& Nbsp; Package & nbsp; Architecture & nbsp; & nbsp; version & nbsp; Source & nbsp; & nbsp; Size
========================================================== ==========================================================
Installing:
& Nbsp; community-mysql-server & nbsp; x86_64 & nbsp; 5.5.35-1. fc20 & nbsp; updates & nbsp; 8.8 M
Install for dependency:
& Nbsp; community-mysql & nbsp; x86_64 & nbsp; 5.5.35-1. fc20 & nbsp; updates & nbsp; 4.9 M
& Nbsp; community-mysql-common & nbsp; x86_64 & nbsp; 5.5.35-1. fc20 & nbsp; updates & nbsp; 208 k
Transaction Summary
========================================================== ==========================================================
Install & nbsp; 1 Software Package (+ 2 dependent Software Package)
Total downloads: 14 MB
Installation size: 78 MB
Downloading packages:
(1/3): community-mysql-5.5.35-1.fc20.x86_64.rpm & nbsp; | 4.9 MB & nbsp; 00:04 & nbsp;
(2/3): community-mysql-common-5.5.35-1.fc20.x86_64.rpm & nbsp; | 208 kB & nbsp; 00:00 & nbsp;
(3/3): community-mysql-server-5.5.35-1.fc20.x86_64.rpm & nbsp; | 8.8 MB & nbsp; 00:03 & nbsp;
--------------------------------------------------------------------------------
Total & nbsp; & nbsp; 1.4 MB/s | & nbsp; 14 MB & nbsp; 00:09 & nbsp;
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
& Nbsp; installing & nbsp;: community-mysql-common-5.5.35-1.fc20.x86_64 & nbsp; 1/3 & nbsp;
& Nbsp; installing & nbsp;: community-mysql-5.5.35-1.fc20.x86_64 & nbsp; & nbsp; & nbsp ;& nbsp; 2/3 & nbsp;
& Nbsp; installing & nbsp;: community-mysql-server-5.5.35-1.fc20.x86_64 & nbsp; 3/3 & nbsp;
& Nbsp; in verification & nbsp;: community-mysql-5.5.35-1.fc20.x86_64 & nbsp; & amp; nbsp; 1/3 & amp; nbsp;
& Nbsp; in verification & nbsp;: community-mysql-server-5.5.35-1.fc20.x86_64 & nbsp; 2/3 & nbsp;
& Nbsp; in verification & nbsp;: community-mysql-common-5.5.35-1.fc20.x86_64 & nbsp; 3/3 & nbsp;
Installed:
Community-mysql-server.x86_64 0: 5. 5.35-1. fc20 & nbsp; & nbsp;
Installed as dependencies:
Community-mysql.x86_64 0: 5. 5.35-1. fc20 & nbsp; & nbsp;
Community-mysql-common.x86_64 0: 5. 5.35-1. fc20 & nbsp; & nbsp;
Finished!
[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 & nbsp; # log on to the database as root
Welcome to the MySQL monitor. & nbsp; Commands end with; or \ g.
Your MySQL connection id is 2
Server version: 5.5.35 MySQL Community Server (GPL)
Copyright (c) 2000,201 3, 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; & nbsp; # user list
+ ------ + ----------- + ---------- +
| User | host & nbsp; | password |
+ ------ + ----------- + ---------- +
| Root | localhost | & nbsp; |
| Root | rachel & nbsp; |
| Root | 127.0.0.1 | & nbsp; |
| Root |: 1 & nbsp; |
| & Nbsp; | localhost | & nbsp; |
| & Nbsp; | rachel & nbsp; |
+ ------ + ----------- + ---------- +
6 rows in set (0.00 sec)
Mysql> delete from mysql. user where user = ''; # delete an empty user
Query OK, 2 rows affected (0.00 sec)
Mysql> delete from mysql. user where user = 'root' and host = ': 1'; # delete an IPv6 user (if not used)
Query OK, 1 row affected (0.00 sec)
Mysql> select user, host, password from mysql. user;
+ ------ + ----------- + ---------- +
| User | host & nbsp; | password |
+ ------ + ----------- + ---------- +
| Root | localhost | & nbsp; |
| Root | rachel & nbsp; |
| Root | 127.0.0.1 | & nbsp; |
+ ------ + ----------- + ---------- +
3 rows in set (0.00 sec)
# Set Password
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 @ '192. 0.0.1 '= password ('xxxxxxx ');
Query OK, 0 rows affected (0.00 sec)
# Columns password again
Mysql> select user, host, password from mysql. user;
+ ------ + ----------- + --------------------------------------------- +
| User | host & nbsp; | password & nbsp; & nbsp; |
+ ------ + ----------- + --------------------------------------------- +
| Root | localhost | * c7e2f6338326edc0axxxxxxxxxxxxxxxxxxxxx |
| Root | rachel & nbsp; | * c7e2f6338326edc0axxxxxxxxxxxxxxxxxxxxx |
| Root | 127.0.0.1 | * c7e2f6338326edc0axxxxxxxxxxxxxxxxxxxxx |
+ ------ + ----------- + --------------------------------------------- +
3 rows in set (0.00 sec)
Mysql> exit
Bye
[Root @ rachel densintian] # mysql-u root-p # log on again
Enter password: & nbsp; & nbsp; # enter your password
Welcome to the MySQL monitor. & nbsp; Commands end with; or \ g.
Your MySQL connection id is 3
Server version: 5.5.35 MySQL Community Server (GPL)
Copyright (c) 2000,201 3, 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] # & nbsp;