This article mainly introduces the two MySQL5.6.35 databaseinstallation tutorials under win10 in detail. It has certain reference value and interested friends can refer to it.
Record the installation of two MySQL5.6.35 databases under win10, the details are as follows
Environment:
OS:window10
DB:MYSQL5.6.35 installation-free Version
1. Install the first MySQL normally (see my last blog)
2. In Management->Services and Applications->Services, stop the first mysql Service
3. copyall the directories and files under the first database (my installation directory is: C:\software\mysql-5.6.35-winx64) to another A path, here I copy it to C:\software, and rename the file to MySQL3307
4. Change the my-default.ini file under the database file after copying, and change the port number to 3307 (custom , first check whether the port is occupied)
[client] port=3307 default-character-set=utf8 [mysqld] # 设置为MYSQL的安装目录 basedir=C:/software/MySQL3307/MySQL3307 # 设置为MYSQL的数据目录 datadir=C:/software/MySQL3307/MySQL3307/data port=3307 character_set_server=utf8 default-storage-engine=MYISAM sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
5. Create a startup service and open the command line with administrator rights (cannot use window+R – >Open in cmd mode, otherwise it will not be installed later), cd into the bin folder of the second database directory, and run the following command
mysqld install MySQL3307 --defaults-file=" C:\software\MySQL3307\MySQL3307\my-default.ini"
If the installation is successful, it will prompt that the installation is successful
6. Modify the registry
HKEY_LOCAL_MACHINE–>SYSTEM–>CurrentControlSet–>Services
Find the MySQL3307 just created and modify the ImagePath to the following
":C:\software\MySQL3307\MySQL3307\bin\mysqld" --defaults-file="E:\MySQL\mysql_base\ini\my.ini" MySQL3307
7. Start services
In Management->Services and Applications->Services, start two services
8. Test
Connect to the newly created database through Navicat for MySQL. The password is the same as the first database. The test is OK.
【Related recommendations】
1. Special recommendation:"php Programmer Toolbox" V0.1 version download
2. Free mysql online video tutorial
##3.Those things about database design
The above is the detailed content of How to install two MySQL5.6.35 under win10?. For more information, please follow other related articles on the PHP Chinese website!

MySQLhandlesconcurrencyusingamixofrow-levelandtable-levellocking,primarilythroughInnoDB'srow-levellocking.ComparedtootherRDBMS,MySQL'sapproachisefficientformanyusecasesbutmayfacechallengeswithdeadlocksandlacksadvancedfeatureslikePostgreSQL'sSerializa

MySQLhandlestransactionseffectivelyusingtheInnoDBengine,supportingACIDpropertiessimilartoPostgreSQLandOracle.1)MySQLusesREPEATABLEREADasthedefaultisolationlevel,whichcanbeadjustedtoREADCOMMITTEDforhigh-trafficscenarios.2)Itoptimizesperformancewithabu

Best practices include: 1) Understanding the data structure and MySQL processing methods, 2) Appropriate indexing, 3) Avoid SELECT*, 4) Using appropriate JOIN types, 5) Use subqueries with caution, 6) Analyzing queries with EXPLAIN, 7) Consider the impact of queries on server resources, 8) Maintain the database regularly. These practices can make MySQL queries not only fast, but also maintainability, scalability and resource efficiency.

MySQLisbetterforspeedandsimplicity,suitableforwebapplications;PostgreSQLexcelsincomplexdatascenarioswithrobustfeatures.MySQLisidealforquickprojectsandread-heavytasks,whilePostgreSQLispreferredforapplicationsrequiringstrictdataintegrityandadvancedSQLf

MySQL processes data replication through three modes: asynchronous, semi-synchronous and group replication. 1) Asynchronous replication performance is high but data may be lost. 2) Semi-synchronous replication improves data security but increases latency. 3) Group replication supports multi-master replication and failover, suitable for high availability requirements.

The EXPLAIN statement can be used to analyze and improve SQL query performance. 1. Execute the EXPLAIN statement to view the query plan. 2. Analyze the output results, pay attention to access type, index usage and JOIN order. 3. Create or adjust indexes based on the analysis results, optimize JOIN operations, and avoid full table scanning to improve query efficiency.

Using mysqldump for logical backup and MySQLEnterpriseBackup for hot backup are effective ways to back up MySQL databases. 1. Use mysqldump to back up the database: mysqldump-uroot-pmydatabase>mydatabase_backup.sql. 2. Use MySQLEnterpriseBackup for hot backup: mysqlbackup--user=root-password=password--backup-dir=/path/to/backupbackup. When recovering, use the corresponding life

The main reasons for slow MySQL query include missing or improper use of indexes, query complexity, excessive data volume and insufficient hardware resources. Optimization suggestions include: 1. Create appropriate indexes; 2. Optimize query statements; 3. Use table partitioning technology; 4. Appropriately upgrade hardware.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Dreamweaver CS6
Visual web development tools

WebStorm Mac version
Useful JavaScript development tools

Atom editor mac version download
The most popular open source editor

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
