Windows下MySQL多实例运作-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Windows下MySQL多实例运作

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:27 PM

mysqlwindowsExampleOperation

Windows下MySQL多实例运行
关键字：Windows下MySQL多实例运行

阅读前注意事项：
1、有的版本的data目录不直接放在mysql安装目录下，有可能在：C:\ProgramData\MySQL\MySQL Server 5.1\data（不管路径在哪里指定正确的路径即可）
2、操作步骤：复制MySQL安装目录-->修改my.ini中的端口2处、安装目录和数据目录---->命令安装MySQL windows服务--->修改注册表---->启动新实例的window服务---->正常使用
正文篇：
    1.正常安装Windows版的MySQL，例如安装在d:\MySQL文件夹里；
    2.按照常规配置好MySQL；
    3.复制备份安装好的文件夹，命名为“MySQL_3307"; 删除 data目录下的文件其他文件夹，只剩 test和mysql文件夹；
    4.修改“d:\MySQL_3307" 下的my.ini 端口为3307
    Java代码
    [client]
    port=3307
    [mysqld]
    # The TCP/IP Port the MySQL Server will listen on
    port=3307

    程序路径改为 d:/MySQL_3307

    Java代码
    [mysqld]
    # The TCP/IP Port the MySQL Server will listen on
    port=3307
    #Path to installation directory. All paths are usually resolved relative to this.
    basedir="d:/MySQL_3307"
    #Path to the database root
    datadir="d:/MySQL_3307/Data/"

    5.在cmd命令行模式下，进入第2个MySQL_3307的\bin文件夹。
    执行mysqld install MySQL_3307命令。作用是为Mysql安装一个服务，服务名是MySQL_3307，
    6.完毕后，在运行里运行REGEDIT，打开WINDOWS注册表编辑器，
    在HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL_3307打开，
    修改下面的ImagePath数值： "D:\MySQL_3307\bin\mysqld" --defaults-file="D:\MySQL_3307\my.ini" MySQL_3307
    确定，退出注册表编辑器。
    7.然后就可以在服务管理里正常启动MySQL_3307服务。

    注：若想重命名mysql服务名称，
    1.进入services.msc关闭MySQL服务
    2.C:\>sc delete MySQL “MySQL”为服务名称
    3.重复上面的第6、7步即可
    删除服务后，进入到注册表里，看旧的mysql节点是否删除。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How to Grant Permissions to New MySQL UsersMay 09, 2025 am 12:16 AM

TograntpermissionstonewMySQLusers,followthesesteps:1)AccessMySQLasauserwithsufficientprivileges,2)CreateanewuserwiththeCREATEUSERcommand,3)UsetheGRANTcommandtospecifypermissionslikeSELECT,INSERT,UPDATE,orALLPRIVILEGESonspecificdatabasesortables,and4)

How to Add Users in MySQL: A Step-by-Step GuideMay 09, 2025 am 12:14 AM

ToaddusersinMySQLeffectivelyandsecurely,followthesesteps:1)UsetheCREATEUSERstatementtoaddanewuser,specifyingthehostandastrongpassword.2)GrantnecessaryprivilegesusingtheGRANTstatement,adheringtotheprincipleofleastprivilege.3)Implementsecuritymeasuresl

MySQL: Adding a new user with complex permissionsMay 09, 2025 am 12:09 AM

ToaddanewuserwithcomplexpermissionsinMySQL,followthesesteps:1)CreatetheuserwithCREATEUSER'newuser'@'localhost'IDENTIFIEDBY'password';.2)Grantreadaccesstoalltablesin'mydatabase'withGRANTSELECTONmydatabase.TO'newuser'@'localhost';.3)Grantwriteaccessto'

MySQL: String Data Types and CollationsMay 09, 2025 am 12:08 AM

The string data types in MySQL include CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and TEXT. The collations determine the comparison and sorting of strings. 1.CHAR is suitable for fixed-length strings, VARCHAR is suitable for variable-length strings. 2.BINARY and VARBINARY are used for binary data, and BLOB and TEXT are used for large object data. 3. Sorting rules such as utf8mb4_unicode_ci ignores upper and lower case and is suitable for user names; utf8mb4_bin is case sensitive and is suitable for fields that require precise comparison.

MySQL: What length should I use for VARCHARs?May 09, 2025 am 12:06 AM

The best MySQLVARCHAR column length selection should be based on data analysis, consider future growth, evaluate performance impacts, and character set requirements. 1) Analyze the data to determine typical lengths; 2) Reserve future expansion space; 3) Pay attention to the impact of large lengths on performance; 4) Consider the impact of character sets on storage. Through these steps, the efficiency and scalability of the database can be optimized.

MySQL BLOB : are there any limits?May 08, 2025 am 12:22 AM

MySQLBLOBshavelimits:TINYBLOB(255bytes),BLOB(65,535bytes),MEDIUMBLOB(16,777,215bytes),andLONGBLOB(4,294,967,295bytes).TouseBLOBseffectively:1)ConsiderperformanceimpactsandstorelargeBLOBsexternally;2)Managebackupsandreplicationcarefully;3)Usepathsinst

MySQL : What are the best tools to automate users creation?May 08, 2025 am 12:22 AM

The best tools and technologies for automating the creation of users in MySQL include: 1. MySQLWorkbench, suitable for small to medium-sized environments, easy to use but high resource consumption; 2. Ansible, suitable for multi-server environments, simple but steep learning curve; 3. Custom Python scripts, flexible but need to ensure script security; 4. Puppet and Chef, suitable for large-scale environments, complex but scalable. Scale, learning curve and integration needs should be considered when choosing.

MySQL: Can I search inside a blob?May 08, 2025 am 12:20 AM

Yes,youcansearchinsideaBLOBinMySQLusingspecifictechniques.1)ConverttheBLOBtoaUTF-8stringwithCONVERTfunctionandsearchusingLIKE.2)ForcompressedBLOBs,useUNCOMPRESSbeforeconversion.3)Considerperformanceimpactsanddataencoding.4)Forcomplexdata,externalproc

See all articles