The server/client installation package for MySQL is available in CentOS 6 or earlier versions, but CentOS 7 has used MariaDB instead of the default MySQL. MARIADB database management System is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL licensing MARIADB is fully compatible with MySQL, including the API and command line, so that it can easily become a substitute for MySQL.
Install MARIADB official documents under Linux see: https://mariadb.com/kb/zh-cn/installing-mariadb-with-yum/
Delete all mysql/mariadb
MySQL is no longer included in the CentOS 7 source, but instead MariaDB;
1. Using Rpm-qa | grep MariaDB searches for MariaDB existing packages:
If present, use RPM-E--nodeps mariadb-* to remove all:
[Email protected] ~]# Rpm-qa | grep mariadbmariadb-server-5.5.52-1. el7.x86_64mariadb-libs-5.5.52-1~]# rpm-e mysql-* Error: Package not installed MySQL
2. Using Rpm-qa | grep MariaDB searches for MariaDB existing packages:
If present, use yum remove MySQL mysql-server mysql-libs compat-mysql51 all deleted;
[[email protected] ~]# yum remove MySQL mysql-server mysql-libs compat- mysql51 Loaded plugin: fastestmirror, langpacks parameter mysql has no matching parameters mysql -server No matching parameters compat< /span>-mysql51 no match is being resolved dependency --> checking transactions ---> Package mariadb-libs.x86_64.1.5.5.52-1.EL7 will be deleted -processing dependencies libmysqlclient.so.18 () (64bit), which is packaged Perl-dbd-mysql-4.023-5.el7.x86_64 requires -- > is dealing with Dependency libmysqlclient.so.18 () (64bit), which is 2:postfix-2.10.1-6.el7.x86_64 needs -Processing Dependency libmysqlclient.so.18 () (64bit), which is required by package 1:qt-mysql-4.8.5-13.el7.x86_64 ....
Delete: mariadb-libs.x86_64 1:5.5.52-1. El7 as dependency removed: akonadi-mysql.x86_64 0:1.9.2-4.el7 mariadb-server.x86_64 1:5.5.52-1. El7 perl-dbd-mysql.x86_64 0:4.023-5.el7 postfix.x86_64 2:2.10.1-6. El7 qt-mysql.x86_64 1:4.8.5-13. El7 ~]# rpm-qa| ~]#
3. Start a new installation, create a Mariadb.repo file
Vi/etc/yum.repos.d/mariadb.repo
Insert the following content:
# MariaDB 10.2.4 CentOS repository list-created 2017-05-05 16:13 utc# http://downloads.mariadb.org/mariadb/repositories /[mariadb]name = Mariadbbaseurl = http://yum.mariadb.org/10.2.4/centos7-amd64gpgkey=https://yum.mariadb.org/ Rpm-gpg-key-mariadbgpgcheck=1
System and Version selection: https://downloads.mariadb.org/mariadb/repositories/#mirror =tuna
4. Run the install command to install MARIADB
[Email protected] ~]# yum-y install Mariadb-server mariadb-Client Loaded plugin: Fastestmirror, langpacksmariadb| 2.9 KB 00:00mariadb/primary_db | KB 00:09Determining fastest Mirrors*base:mirrors.btte.net*extras:mirrors.zju.edu.cn*updates:mirrors.zju.edu.cn is addressing dependencies-Checking Transactions---> Package mariadb-client.x86_64.0.10.2.4-1. El7.centos will be installed--The dependency Mariadb-common is being processed and it is mariadb-client-10.2.4-1 by the package. el7.centos.x86_64 needs---> Package mariadb-server.x86_64.0.10.2.4-1. El7.centos will be installed--The dependency galera is being processed and it is mariadb-server-10.2.4-1 by the package. el7.centos.x86_64 needs--Is processing dependency libjemalloc.so.1 () (64bit), which is mariadb-server-10.2.4-1 by the package. el7.centos.x86_64 needs-Checking Transactions---> Package mariadb-common.x86_64.0.10.2.4-1. El7.centos will be installed--The dependency mariadb-compat is being processed and it is mariadb-common-10.2.4-1 by the package. el7.centos.x86_64 needs---> Package galera.x86_64.0.25.3.19-1. Rhel7.el7.centos will be installed---> Package jemalloc.x86_64.0.3.6.0-1. EL7 will be installed-Checking Transactions---> Package mariadb-compat.x86_64.0.10.2.4-1. El7.centos will be installed-resolve dependencies to complete dependency relationships================================================================================Package schema version source size================================================================================Installing: MariaDB-client x86_64 10.2.4-1.el7.centos mariadb 48M MariaDB-server x86_64 10.2.4-1.el7.centos mariadb 113m installed for dependency: MariaDB-common x86_64 10.2.4-1.el7.centos mariadb 104k MariaDB-compat x86_64 10.2.4-1.el7.centos mariadb 2.8M Galera x86_6425.3.19-1.rhel7.el7.centos MARIADB 8.0M Jemalloc x86_643.6.0-1.EL7 MARIADB 104k Transaction Summary================================================================================installation2 Packages (+4dependent packages) ....
Download the installation package first, then install it automatically, and start the MARIADB service after the installation is successful.
Systemctl start mariadb #启动服务systemctl enable mariadb #设置开机启动systemctl restart mariadb #重新启动systemctl Stop Mariadb.servic E #停止MariaDB
5. Log in to the database
Log in to mariadb with the Mysql-uroot command, and the password for the root account is empty.
6. Make a simple configuration of mariadb and configure it with the Mysql_secure_installation command.
Mysql_secure_installation
The first is to set the password, you will be prompted to enter the password
Enter current password to root (enter for none): <– First run direct carriage return
Set Password
Set root Password? [y/n] <– whether to set the root user password, enter Y and return or direct enter
New Password: <– Set the root user's password
Re-enter new password: <– Enter the password you set again
Other configurations
Remove anonymous users? [y/n] <– Whether to delete anonymous users, enter
Disallow Root login remotely? [y/n] <– Whether root login is forbidden, enter,
Remove test database and access to it? [y/n] <– Whether to delete the test database, enter
Reload privilege tables now? [y/n] <– whether to reload the permissions table, enter
Initialize MARIADB complete, next Test login
Mysql-uroot-ppassword
Complete.
7. Configuring the MARIADB Character Set
File/etc/my.cnf
Vi/etc/my.cnf
Add under the [Mysqld] tab
init_connect= ' Set collation_connection = Utf8_unicode_ci ' init_connect= ' Set NAMES UTF8 ' Character-set-server=utf8 Collation-server=utf8_unicode_ci Skip-character-set-client-handshake
File/etc/my.cnf.d/client.cnf
Vi/etc/my.cnf.d/client.cnf
Add in [client]
Default-character-set=utf8
File/etc/my.cnf.d/mysql-clients.cnf
Vi/etc/my.cnf.d/mysql-clients.cnf
Add in [MySQL]
Default-character-set=utf8
Complete configuration, restart MARIADB
Systemctl Restart MARIADB
Then enter MARIADB to view the character set
Mysql> Show variables like "%character%", show variables like "%collation%";
Displayed as
+--------------------------+----------------------------+| variable_name | Value |+--------------------------+----------------------------+| character_set_client | UTF8 | | character_set_connection | UTF8 | | Character_set_database | UTF8 | | Character_set_filesystem | binary | | Character_set_results | UTF8 | | Character_set_server | UTF8 | | Character_set_system | UTF8 | | Character_sets_dir | /usr/share/mysql/charsets/|+--------------------------+----------------------------+8 rows in Set (0.00sec)+----------------------+-----------------+| variable_name | Value |+----------------------+-----------------+| collation_connection | Utf8_unicode_ci | | Collation_database | Utf8_unicode_ci | | Collation_server | Utf8_unicode_ci |+----------------------+-----------------+3 rows in Set (0.00 sec)
The character set configuration is complete.
8. Add users, set permissions
Create user command
mysql>create user [email protected] identified by ' password ';
Direct creation of user and authorized commands
Mysql>grant all on * * to [e-mail protected] indentified by ' password ';
Grant access to the extranet
Mysql>grant all privileges on * * to [e-mail protected] '% ' identified by ' password ';
Grant permissions and can authorize
Mysql>grant all privileges on * * to [e-mail protected] ' hostname ' identified by ' password ' with GRANT option;
Simple user and permission configuration is basically the case.
Where only partial permissions are granted to change all privileges or all to Select,insert,update,delete,create,drop,index,alter,grant,references,reload, Shutdown,process,file part of it.
Linux System Tutorial: How to check the MARIADB server version http://www.linuxidc.com/Linux/2015-08/122382.htm
Realization of Read and write separation of MariaDB proxy http://www.linuxidc.com/Linux/2014-05/101306.htm
Linux compiler installation Configuration mariadb database method http://www.linuxidc.com/Linux/2014-11/109049.htm
The CentOS system uses Yum to install the MARIADB database http://www.linuxidc.com/Linux/2014-11/109048.htm
Install mariadb and MySQL coexist http://www.linuxidc.com/Linux/2014-11/109047.htm
Install mariadb under CentOS7 using Yum