Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to install and configure the mysql database of centos7 system. I hope I can add and update some knowledge to you. If you have any other questions you need to know, you can continue to follow my updated article in the industry information.

Installation and configuration of centos7 mysql database I. system environment

The system version after yum update upgrade is

[root@yl-web yl] # cat / etc/redhat-release CentOS Linux release 7.1.1503 (Core) II. Mysql installation

Generally speaking, the information given on the Internet is

# yum install mysql#yum install mysql-server#yum install mysql-devel

Installation of both mysql and mysql-devel succeeded, but installation of mysql-server failed, as follows:

[root@yl-web yl] # yum install mysql-serverLoaded plugins: fastestmirrorLoading mirror speeds from cached hostfile * base: mirrors.sina.cn * extras: mirrors.sina.cn * updates: mirrors.sina.cnNo package mysql-server available.Error: Nothing to do

It was found that the CentOS 7 version removed the MySQL database software from the default program list and replaced it with mariadb.

There are two solutions:

1. Method 1: install mariadb

MariaDB database management system is a branch of MySQL, which is mainly maintained by the open source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of shutting down MySQL, so the community uses a branching approach to avoid this risk. The goal of MariaDB is to be fully compatible with MySQL, including API and the command line, making it an easy replacement for MySQL.

Install mariadb, size 59m.

[root@yl-web yl] # yum install mariadb-server mariadb

The relevant commands for the mariadb database are:

Systemctl start mariadb # launch MariaDB

Systemctl stop mariadb # stop MariaDB

Systemctl restart mariadb # restart MariaDB

Systemctl enable mariadb # set boot up

So start the database first.

[root@yl-web yl] # systemctl start mariadb

Then you can use mysql normally.

[root@yl-web yl] # mysql-u root-pEnter password: Welcome to the MariaDB monitor Commands end with; or\ g.Your MariaDB connection id is 3Server version: 5.5.41-MariaDB MariaDB ServerCopyright (c) 2000, 2014, 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.00 sec) MariaDB [(none)] >

After installing mariadb, it also shows MariaDB [(none)] >, which may seem a little unaccustomed. Here is the second method.

2. Method 2: download and install mysql-server# 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 on the official website

Restart the mysql service after successful installation.

# service mysqld restart

The initial installation of the mysql,root account does not have a password.

[root@yl-web yl] # 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) mysql >

Set password

Mysql > set password for 'root'@'localhost' = password (' password'); Query OK, 0 rows affected (0.00 sec) mysql >

There is no need to restart the database to take effect.

During the mysql installation process, the following:

Installed: mysql-community-client.x86_64 0rig 5.6.26-2.el7 mysql-community-devel.x86_64 0vir 5.6.26-2.el7 mysql-community-libs.x86_64 0vir 5.6.26-2.el7 mysql-community-server.x86_64 0vir 5.6.26-2.el7 Dependency Installed: mysql-community -common.x86_64 0VOR 5.6.26-2.el7 Replaced: mariadb.x86_64 1VR 5.5.41-2.el7_0 mariadb-devel.x86_64 1V 5.5.41-2.el7_0 mariadb-libs.x86_64 1V 5.5.41-2.el7_0 Mariadb-server.x86_64 1Rank 5.5.41-2.el7_0

So after installation, mariadb is automatically replaced and will no longer take effect.

[root@yl-web yl] # rpm-qa | grep mariadb [root@yl-web yl] # III. Configure mysql1 and encode

The mysql configuration file is / etc/my.cnf

Finally, add the coding configuration.

[mysql] default-character-set = utf8

The character encoding here must be the same as in / usr/share/mysql/charsets/Index.xml.

2. Remote connection settings

Assign all permissions on all tables in all databases to root users at all IP addresses.

Mysql > grant all privileges on *. * to root@'%'identified by 'password'

If it is a new user instead of root, create a new user first

Mysql > create user 'username'@'%' identified by' password'

At this point, you can connect remotely.

Read the above about centos7 system mysql database installation and configuration, I hope it can bring some help to everyone in practical application. Due to the limited space in this article, it is inevitable that there will be deficiencies and need to be supplemented. If you need more professional answers, you can contact us on the official website for 24-hour pre-sales and after-sales to help you answer questions at any time.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.