Multi-instance installation MySQL database

1:yum Installing the Database
Rpm-q Mariadb-server
Yum Install Mariadb-server
2: Start the service
Systemctl Start mariadb
3: Database path, file

4: Configuration file Mysql.sock file (native communication)

5: Create new folder and specify owner, owning group

6: Build database and view program path
mysql_install_db--datadir=/mysqldb/3306/data--user=mysql--basedir=/usr
mysql_install_db--datadir=/mysqldb/3307/data--user=mysql--basedir=/usr
mysql_install_db--datadir=/mysqldb/3308/data--user=mysql--basedir=/usr

7: Prepare the configuration file (Note Add port default 3306)

8: Close the previous 3306 ports
[[email protected]/mysqldb/3306] #systemctl stop mariadb
9: Copy the startup script and change the permissions to 700


10: Start the service

11: Connect MySQL Database 3307

Multi-instance installation MySQL database