Centos7 mysql installation, centos7mysql
I. System Environment
[Root @ localhost home] # cat/etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
Ii. Install mysql
The installation of mysql and mysql-devel is successful, but the installation of mysql-server fails as follows:
[Root @ localhost home] # yum install mysql-server loaded plug-in: fastestmirror, langpacks Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast base | 3.6 kB 00:00:00 extras | 3.4 kB 00:00:00 updates | 3.4 kB 00:00:00 (1/4): base/7/x86_64/group_gz | 155 kB 00:00:01 (2/4 ): extras/7/x86_64/primary_db | 139 kB 00:00:01 (3/4): base/7/x86_64/primary_db | 5.6 MB 00:00:38 (4/4 ): updates/7/x86_64/primary_db | 4.7 MB 00:00:39 Loading mirror speeds from cached hostfile * base: mirrors.163.com * extras: mirrors.163.com * u Pdates: mirrors.163.com there is no available mysql-server software package. Error: No need to handle
This problem occurs when MySQL database software is removed from the default program list in CentOS 7 and replaced by mariadb.
There are two solutions:
1. Method 1: Install mariadb
The MariaDB database management system is a branch of MySQL. The purpose of using GPL to authorize MariaDB is to be fully compatible with MySQL, including APIs and command lines, so that it can easily become a substitute for MySQL. MariaDB was developed by Michael Widenius, the founder of MySQL. He sold his own company MySQL AB to SUN. Since then, as SUN was acquired by Oracle, the ownership of MySQL also falls into the hands of Oracle. MariaDB is named by Michael Widenius's daughter Maria.
Install mariadb and enter the installation command
[Root @ localhost home] # yum install mariadb-server mariadb
The commands related to the mariadb database are:
Systemctl start mariadb # start MariaDB
Systemctl stop mariadb # stop MariaDB
Systemctl restart mariadb # restart MariaDB
Systemctl enable mariadb # Set startup
Start the database first
[Root @ yl-web yl] # systemctl start mariadb
No password by default
[root@localhost lzh]# mysql -u root -pEnter password: Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 6Server version: 5.5.52-MariaDB MariaDB ServerCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test |+--------------------+4 rows in set (0.01 sec)
2. Method 2: download and install mysql-server on the official website
# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm# rpm -ivh mysql-community-release-el7-5.noarch.rpm# yum install mysql-community-server
Restart the mysql service after successful installation.
# Service mysqld restart
The first time mysql is installed, the root account has no password
[root@localhost lzh]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.6.26 MySQL Community Server (GPL)Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test |+--------------------+4 rows in set (0.01 sec)
Set Password
mysql> set password for 'root'@'localhost' =password('password');Query OK, 0 rows affected (0.00 sec)
After installation, mariadb is automatically replaced and will no longer take effect.
[root@localhost lzh]# rpm -qa |grep mariadb