Install MySQL under Fedora20

After Fedora19, Fedora replaces mysql with mariadb. Although these two things are the same, I still like mysql, and I don't know why. Under Fedora20 (64bit), I only installed mariadb once, and I couldn't find a solution on the Internet. (If anyone knows, please don't hesitate to give me some advice. Thank you * ^_^ *) The Installation log [root @ racheldensintian] # yum-yin below is Fedora20.

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-google chrome 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

========================================================== ==========================================================
Package architecture version source size
========================================================== ==========================================================
Installing:
Community-mysql-server x86_64 5.5.35-1. fc20 updates 8.8 M
Install for dependency:
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

Transaction Summary
========================================================== ==========================================================
Install 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 | 4.9 MB
(2/3): community-mysql-common-5.5.35-1.fc20.x86_64.rpm | 208 kB
(3/3): community-mysql-server-5.5.35-1.fc20.x86_64.rpm | 8.8 MB
--------------------------------------------------------------------------------
1.4 MB/s in total | 14 MB
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing: community-mysql-common-5.5.35-1.fc20.x86_64 1/3
Installing: community-mysql-5.5.35-1.fc20.x86_64 2/3
Installing: community-mysql-server-5.5.35-1.fc20.x86_64 3/3
In verification: community-mysql-5.5.35-1.fc20.x86_64 1/3
In verification: community-mysql-server-5.5.35-1.fc20.x86_64 2/3
In verification: community-mysql-common-5.5.35-1.fc20.x86_64 3/3

Installed:
Community-mysql-server.x86_64. 5.35-1. fc20

Installed as dependencies:
Community-mysql.x86_64. 5.35-1. fc20
Community-mysql-common.x86_64. 5.35-1. fc20

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 # log on to the database as 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,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; # user list
+ ------ + ----------- + ---------- +
| 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 = ''; # 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 | password |
+ ------ + ----------- + ---------- +
| Root | localhost |
| Root | rachel |
| Root | 127.0.0.1 |
+ ------ + ----------- + ---------- +
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 | password |
+ ------ + ----------- + --------------------------------------------- +
| Root | localhost | * c7e2f6338326edc0axxxxxxxxxxxxxxxxxxxxx |
| Root | rachel | * 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: # Enter the 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,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] #

For more information about Fedora, see Fedora topics page http://www.linuxidc.com/topicnews.aspx? Tid = 5