Methods and problems encountered in installing mariadb in centos under mysql

Delete the previously installed mariadb

1. Use rpm -qa | grep mariadb to search for the existing MariaDB package:

If it exists, use rpm -e --nodeps mariadb-*全部刪除:

[root@localhost ~]# rpm -qa | grep mariadb
mariadb-server-5.5.52-1.el7.x86_64
mariadb-libs-5.5.52-1.el7.x86_64
[root@localhost ~]# rpm -e mysql-*
Error: Package mysql-* not installed

2. Use rpm -qa | grep mariadb to search for the existing MariaDB package:

If it exists, use yum remove mysql mysql-server mysql-libs compat-mysql51 to delete all;

[root@localhost ~]# yum remove mysql mysql-server mysql-libs compat-mysql51
Loaded plugins: fastestmirror, langpacks
Parameter mysql has no match Parameter mysql-server has no match Parameter compat-mysql51 has no match Resolving dependencies
--> Checking transactions
---> Package mariadb-libs.x86_64.1.5.5.52-1.el7 will be removed
--> Processing dependency libmysqlclient.so.18()(64bit) required by package perl-DBD-MySQL-4.023-5.el7.x86_64
--> Processing dependency libmysqlclient.so.18()(64bit), required by package 2:postfix-2.10.1-6.el7.x86_64
--> Processing dependency libmysqlclient.so.18()(64bit), required by package 1:qt-mysql-4.8.5-13.el7.x86_64..........

Install mariadb

Installation command:

Start command:

Add startup

Simple configuration

Enter command line mode

mysql -uroot -p

Problems encountered

Host is not allowed to connect to this MySQL server

MySQL does not allow remote login, so remote login fails. The solution is as follows:

Log in to MySQL on the machine where MySQL is installed. mysql -u root -p password and execute use mysql;
Execute update user set host = '%' where user = 'root'; This statement may display an error message after execution, so ignore it.
Execute FLUSH PRIVILEGES;
After the above 4 steps, this problem can be solved.
Note: The fourth step is to refresh the MySQL permission-related tables. Don’t forget it. I didn’t execute the fourth step the first time, and it was always unsuccessful. I finally found the reason.

Summarize

The above is the method and problems encountered in installing mariadb under centos under mysql introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!