mysql install two

MySQL is an open source, free relational database management system that is widely used in Web applications and large enterprise-level database systems. If you need to run multiple versions of MySQL on the same machine, then you need to learn how to install multiple MySQL instances.

This article will introduce how to install two MySQL instances on the Windows operating system for your reference.

1. Download the MySQL installation package

Visit the MySQL official website http://dev.mysql.com/downloads/mysql/ to download the latest version of MySQL Community Server. Here we choose the version as MySQL Community Server 8.0.23, after the download is complete, you need to unzip the files into two different directories, we named them mysql1 and mysql2 respectively.

2. Install MySQL instance

1. Install the first instance

Enter the mysql1 directory and double-click mysql-installer-community-8.0.23.0. The msi installer starts to install MySQL, follow the default settings and proceed to the next step. Finally, in the MySQL Server Configuration Wizard, we can perform some customized configuration operations.

• On the "Type and Networking" page, select the "Developer Default" option;
• On the "Authentication Method" page, select "Use Legacy Authentication Method (Retain MySQL 5.xCompatibity)" " option;
• On the "Accounts and Roles" page, set the password of the "root" user, and keep other options as default;
• On the "Windows Service" page, select "Stand-Alone MySQL Server (Server Machine)" option;
• On the "Apply Configuration" page, click the "Execute" button to apply the configuration and wait for the MySQL service to start and the installation to complete.

2. Install the second instance

Enter the mysql2 directory, use the command line to run the installation program, and execute the following command:

msiexec / i mysql-installer-community-8.0.23.0.msi /qn ^
MYSQL_SRVNAME=MySQL2 ^
INSTALLDIR=C:mysql2 ^
INSTALLDIRDATA=C:mysql2data ^
CONFIGURATIONFILE=config.ini

In the above command, /qn is the quiet mode installation option, MYSQL_SRVNAME is the service name, INSTALLDIR is the installation path of the MySQL instance, INSTALLDIRDATA is the path where the data files are stored, and CONFIGURATIONFILE specifies the path to a configuration file. The installation process is similar to the first instance. After the installation is completed, you can start the service.

3. Configure MySQL instance

1. Configure the first instance

Open the Windows CMD window (run with administrator privileges) and switch to the mysql1 directory bin directory under, execute the following command:

cd /d C:mysql1 in

Then run the mysqld --initialize-insecure --console command to initialize the data directory, and the console outputs MySQL initialization information.

Now, we need to configure some basic information of the MySQL instance by executing the following command:

mysqld --install MySQL1 --defaults-file=../my1.ini

Among them, the --install option installs the service, MySQL1 is the service name, and --defaults-file specifies the configuration file my1.ini.

In my1.ini, write the following:

[mysqld]
datadir=C:/mysql1data
basedir=C:/mysql1
port=3306

Start the MySQL service and execute the following command:

net start MySQL1

Use the following command to log in to the MySQL server:

mysql -uroot -p

2. Configuring the second instance

Switch to the mysql2 directory, we need to first modify the content in the configuration file config.ini to:

[server ]
port=3307
datadir=C:mysql2data
basedir=C:mysql2
default_authentication_plugin=mysql_native_password

After saving, open the Windows CMD window (run with administrator privileges), Execute the following command:

cd /d C:mysql2 in

mysql_ssl_rsa_setup

Then run the mysqld --initialize-insecure --console command to initialize the data directory and console Output MySQL initialization information.

Now, we need to configure some basic information of the MySQL instance by executing the following command:

mysqld --install MySQL2 --defaults-file=../my2.ini

Among them, the --install option installs the service, MySQL2 is the service name, and --defaults-file specifies the configuration file my2.ini.

In my2.ini, write the following:

[mysqld]
port=3307
datadir=C:/mysql2data
basedir=C:/mysql2
default_authentication_plugin=mysql_native_password

Start the MySQL service and execute the following command:

net start MySQL2

Use the following command to log in to the MySQL server:

mysql -uroot -p -P 3307

4. Summary

Through the above steps, you can successfully install two different versions of MySQL instances on the same machine, and set different port numbers and data. Storage directory. MySQL is a feature-rich, scalable database management system that runs on a variety of operating systems and is an important component of any web application that requires data storage. In practical applications, you can install multiple MySQL instances as needed to achieve data separation and better performance.

The above is the detailed content of mysql install two. For more information, please follow other related articles on the PHP Chinese website!