轻松解决在Windows上安装多个Mysql_MySQL
bitsCN.com
问：如何在Windows上安装多个Mysql？ 答：具体方法如下： 1.正常安装Windows版的Mysql，例如安装在d:mysql文件夹里； 2.按照常规配置好Mysql； 3.复制备份安装好的文件夹，比如备份到另外一个文件夹，或者命名为“复件mysql"; 4.运行卸载程序删除安装的MYSQL和文件夹； 5.把备份的mysql文件夹，重新恢复原来的名字，或还原到原来的位置上； 6.再次运行安装程序，安装在另外一个目录，例如：“d:mysql2"。配置端口为3307; 现在，后面安装的第二个Mysql――mysql2肯定是可以正常运行的，下面让起初安装的第一个Mysql 服务正常运行： 在cmd命令行模式下，进入第一个Mysql的in文件夹。 执行mysql-nt install mysql2命令。作用是为Mysql安装一个服务，服务名是mysql2，你也可以自己改名字，比如mysql5，那么命令就是：
mysql-nt install mysql5
完毕后，在运行里运行REGEDIT，打开WINDOWS注册表编辑器，在HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServices项目找到你刚才手动安装的服务， 我这里是mysql2。打开，修改下面的ImagePath数值。 你一般将会看到"D:mysqlinmysqld-nt" mysql2类似的数值。 在mysql-nt"和mysql2之间加入my.ini的路径信息，格式为：
--defaults-file="d:mysqlmy.ini"其中粗体部分替换你的正确的路径， 修改完毕后数据数值一般是类似这个样子：
"D:mysqlinmysqld-nt"
--defaults-file="d:mysqlmy.ini" mysql2
确定，退出注册表编辑器。
然后就可以正常启动mysql2服务了，在CMD窗口下输入命令：
net start mysql2
一般应能正常启动了。 如果遇到提示1067错误，请删除你的mysqlDATA文件里的LOG文件，再试。 如果还是提示1067错误，请检查一下--defaults-file="d:mysqlmy.ini"里面的路径是否写错了； 如果还是提示1067错误……请检查一下你的RP
bitsCN.com
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
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Lossless Scaling on Steam Deck OLED runs games at up to 2x FPS
Aug 26, 2024 am 10:07 AM
ETA Prime recently showcased a paid software called Lossless Scaling on ROG Ally X. While it doesn't actually improve the actual gaming performance, the software enhances the experience by adding frame generation and resolution scaling. These two can
How to update the latest version of Bybit Exchange? Will there be any impact if it is not updated?
Feb 21, 2025 pm 10:54 PM
The way to update ByBit exchanges varies by platform and device: Mobile: Check for updates and install in the app store. Desktop Client: Check for updates in the Help menu and install automatically. Web page: You need to manually access the official website for updates. Failure to update the exchange can lead to security vulnerabilities, functional limitations, compatibility issues and reduced transaction execution efficiency.
deepseek web version entrance deepseek official website entrance
Feb 19, 2025 pm 04:54 PM
DeepSeek is a powerful intelligent search and analysis tool that provides two access methods: web version and official website. The web version is convenient and efficient, and can be used without installation; the official website provides comprehensive product information, download resources and support services. Whether individuals or corporate users, they can easily obtain and analyze massive data through DeepSeek to improve work efficiency, assist decision-making and promote innovation.
Pi Node Teaching: What is a Pi Node? How to install and set up Pi Node?
Mar 05, 2025 pm 05:57 PM
Detailed explanation and installation guide for PiNetwork nodes This article will introduce the PiNetwork ecosystem in detail - Pi nodes, a key role in the PiNetwork ecosystem, and provide complete steps for installation and configuration. After the launch of the PiNetwork blockchain test network, Pi nodes have become an important part of many pioneers actively participating in the testing, preparing for the upcoming main network release. If you don’t know PiNetwork yet, please refer to what is Picoin? What is the price for listing? Pi usage, mining and security analysis. What is PiNetwork? The PiNetwork project started in 2019 and owns its exclusive cryptocurrency Pi Coin. The project aims to create a one that everyone can participate
How to install deepseek
Feb 19, 2025 pm 05:48 PM
There are many ways to install DeepSeek, including: compile from source (for experienced developers) using precompiled packages (for Windows users) using Docker containers (for most convenient, no need to worry about compatibility) No matter which method you choose, Please read the official documents carefully and prepare them fully to avoid unnecessary trouble.
Microsoft introduces gaming handheld-friendly Compact Mode for Xbox Game Bar
Aug 15, 2024 am 06:32 AM
Microsoft has just announced a new Compact Mode for Xbox Game Bar, with a focus on making the overlay more usable on Windows gaming handhelds. These devices usually come with screens that are smaller than 9 inches, and things that are designed for re
Coinsuper exchange software channel official website entrance
Feb 21, 2025 pm 10:39 PM
The official website entrance of the Coinsuper Exchange: https://www.coinsuper.com. The client download channels are: Windows client, macOS client, and mobile (iOS/Android). Registration requires an email, mobile phone number and password, and you need to complete real-name authentication before you can trade. The platform provides a variety of digital asset transactions, including Bitcoin, Ethereum, etc., with the transaction fee rate of 0.1% for both orders and acceptors. Security safeguards include cold wallet storage, dual-factor verification, anti-money laundering and anti-terrorism financing measures, and with security public
BITGet official website installation (2025 beginner's guide)
Feb 21, 2025 pm 08:42 PM
BITGet is a cryptocurrency exchange that provides a variety of trading services including spot trading, contract trading and derivatives. Founded in 2018, the exchange is headquartered in Singapore and is committed to providing users with a safe and reliable trading platform. BITGet offers a variety of trading pairs, including BTC/USDT, ETH/USDT and XRP/USDT. Additionally, the exchange has a reputation for security and liquidity and offers a variety of features such as premium order types, leveraged trading and 24/7 customer support.
