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
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.
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
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
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!