Method for separate login when MariaDB and MySQL coexist

Finally, I completed the login method when MariaDB and MySQL coexist. At that time, I knew that the installation was successful, that is, I could not log on to MariaDB. I would like to share my experiences with you.

Finally, I completed the login method when MariaDB and MySQL coexist. At that time, I knew that the installation was successful, that is, I could not log on to MariaDB. I would like to share my experiences with you.

Finally, I completed the login method when MariaDB and MySQL coexist. At that time, I knew that the installation was successful, that is, I could not log on to MariaDB. I would like to share my experiences with you.

Port Number logon method:

1. In CentOS7 Environment

1. Install Mysql5.6.19. After the installation is successful, the port number is 3306.

[Root @ centOS7] # mysql-uroot-h127.0.0.1-P3306-p

Mysql> select version ();

+ ----------- +

| Version () |

+ ----------- +

| 5.6.19 |

+ ----------- +

1 row in set (0.00 sec)

2. Install MariaDB10.0.12.. After the installation is successful, Port: 3307

[Root @ centOS7] # mysql-uroot-h127.0.0.1-P3307-p

Mysql> select version ();

+ --------------------- +

| Version () |

+ --------------------- +

| 10.0.12-MariaDB-log |

+ --------------------- +

1 row in set (0.00 sec)

The following describes how to install MariaDB10.0.12 after Mysql is installed.

Download the latest binary compilation package tar.gz (currently) and decompress it to your custom directory. This document assumes that the installation directory is/opt.

Create the Directory and symbolic link of the data as follows:

[Root @ centOS7 opt] # mkdir mariadb-data
[Root @ centOS7 opt] # ln-s mariadb-10.0.12-linux-x86_64 mariadb
[Root @ centOS7 opt] # ls-al
Total 20
Drwxr-xr-x. 5 root 4096.
Dr-xr-x. 23 root 4096 ..
Lrwxrwxrwx. 1 root 27 mariadb-> mariadb-10.0.12-linux-x86_64
Drwxr-xr-x. 13 root 4096 mariadb-10.0.12-linux-x86_64
Drwxr-xr-x. 2 root 4096 mariadb-data

Create mariadb and mariadb, and set the permissions of the file:

[Root @ centOS7 opt] # groupadd -- system mariadb
[Root @ centOS7 opt] # useradd-c "MariaDB Server"-d/opt/mariadb-g mariadb -- system mariadb
[Root @ centOS7 opt] # chown-R mariadb: mariadb mariadb-10.0.12-linux-x86_64/
[Root @ centOS7 opt] # chown-R mariadb: mariadb-data/

Copy my. cnf from support-files and create a new my. cnf in the/opt/mariadb directory:

[Root @ centOS7 opt] # cp mariadb/support-files/my-medium.cnf mariadb-data/my. cnf
[Root @ centOS7 opt] # chown mariadb: mariadb-data/my. cnf

Edit the file/opt/mariadb-data/my. cnf: add custom values, socket, port, user, and the most important settings: data DIRECTORY and base directory. the last setting is at least as follows:

[Client]
Port = 3307
Socket =/opt/mariadb-data/mariadb. sock

[Mysqld]
Datadir =/opt/mariadb-data
Basedir =/opt/mariadb
Port = 3307
Socket =/opt/mariadb-data/mariadb. sock
User = mariadb

Copy the init. d script from the support-files file to the corresponding location:

[Root @ centOS7 opt] # cp mariadb/support-files/mysql. server/etc/init. d/mariadb
[Root @ centOS7 opt] # chmod + x/etc/init. d/mariadb

Edit/etc/init. d/mariadb and use mariadb to replace the mysql settings as follows:

-# Provides: mysql
+ # Provides: mariadb
-Basedir =
+ Basedir =/opt/mariadb
-Datadir =
+ Datadir =/opt/mariadb-data
-Lock_file_path = "$ lockdir/mysql"
+ Lock_file_path = "$ lockdir/mariadb"

You need to tell mariadb to read the unique cnf file. add -- defaults-file =/opt/mariadb-data/my after $ bindir/mysqld_safe. cnf. the final parameter settings should be as follows:

# Give extra arguments to mysqld with the my. cnf file. This script
# May be overwritten at next upgrade.
$ Bindir/mysqld_safe -- defaults-file =/opt/mariadb-data/my. cnf -- datadir = "$ datadir" -- pid-file = "$ mysqld_pid_file_path" $ other_args>/dev/null 2> & 1 &

Explicitly specify my. cnf as the input parameter to run mysql_install_db:

[Root @ centOS7 opt] # cd mariadb
[Root @ centOS7 mariadb] # scripts/mysql_install_db -- defaults-file =/opt/mariadb-data/my. cnf

Now you can start MariaDB like this:

[Root @ centOS7 opt] #/etc/init. d/mariadb start
Starting MySQL SUCCESS

Set MariaDB startup to system-level startup:

[Root @ centOS7 opt] # cd/etc/init. d
[Root @ centOS7 init. d] # chkconfig -- add mariadb
[Root @ centOS7 init. d] # chkconfig -- levels 3 mariadb on

Finally, the test now has two database service instances running:

[Root @ centOS7 ~] # Mysql-e "select version ();"
+ ----------- +
| VERSION () |
+ ----------- +
| 5.6.19 |
+ ----------- +
[Root @ mariadb-near-mysql ~] # Mysql-e "select version ();" -- socket =/opt/mariadb-data/mariadb. sock
+ -------------------- +
| VERSION () |
+ -------------------- +
| 10.0.12-MariaDB-log |
+ -------------------- +

Install LAMP (Apache with MariaDB and PHP) in CentOS/RHEL/Scientific Linux 6)

Implementation of MariaDB Proxy read/write splitting

How to compile and install the MariaDB database in Linux

Install MariaDB database using yum in CentOS

Install MariaDB and MySQL

MariaDB details: click here
MariaDB's: click here