MySQLInstanceConfig 命令详解
来源:互联网 发布:互助平台源码 编辑:程序博客网 时间:2024/05/21 20:54
MySQLInstanceConfig:
To use the Instance Configuration Wizard from the command line the following parameters can be used. These parameters have to be set to run from the command line
-n<product name>
-p<path of installation> (no \bin)
-v<version>
Actions to perform
-i (install instance)
-r (remove instance)
-s (stop instance)
-q (be quiet)
-lfilename (write log file)
When launched manually, these can also be submitted
-t<.cnf template filename>
-c<.cnf filename>
Use the following option to define the parameters for the config file generation.
ServiceName=$
AddBinToPath={yes | no}
ServerType={DEVELOPMENT | SERVER | DEDICATED}
DatabaseType={MIXED | INNODB | MYISAM}
ConnectionUsage={DSS | OLTP}
ConnectionCount=#
SkipNetworking={yes | no}
Port=#
StrictMode={yes | no}
Charset=$
RootPassword=$
RootCurrentPassword=$
The return codes of the Wizard in case of an error are.
2 ... Configuration template file cannot be found.
3 ... The Windows service entry cannot be created.
4 ... Could not connect to the Service Control Manager.
5 ... The MySQL service cannot be started.
6 ... The MySQL service cannot be stopped.
7 ... The security settings cannot be applied.
8 ... The configuration file cannot be written.
9 ... The Windows service entry cannot be removed.
Examples:
The following command installs a MySQL Server 5.0 instance from the directory
C:\Programme\MySQL\MySQL Server 5.0 using the service name MySQLCust and settingthe root password to 1234.
MySQLInstanceConfig.exe -i -q "-lC:\mysql_install_log.txt" "-nMySQL Server 5.0"
"-pC:\Programme\MySQL\MySQL Server 5.0" -v5.0.13 "-t..\..\res\my-template.ini" "-cC:\mytest.ini"
ServerType=DEVELOPMENT DatabaseType=MIXED ConnectionUsage=DSS Port=3311
ServiceName=MySQLCust RootPassword=1234
If the server can not be started, the exit code is 2.
The following command removes the server instance with the name MySQLCust.
MySQLInstanceConfig.exe -r -q "-lC:\mysql_install_log.txt" "-nMySQL Server 5.0"
"-pC:\Programme\MySQL\MySQL Server 5.0" -v5.0.13 "-cC:\mytest.ini" ServiceName=MySQLCust
Output into the log file:
----------------------------------------
Welcome to the MySQL Server Instance Configuration Wizard 1.0.6
Date: 2005-10-19 21:53:16
Installing service ...
Product Name: MySQL Server 5.0
Version: 5.0.13
Installation Path: C:\Programme\MySQL\MySQL Server 5.0\
Creating configuration file C:\mytest.ini using template ..\..\res\my-template.ini.
Options:
DEVELOPMENT
MIXED
DSS
STRICTMODE
Variables:
port: 3311
default-character-set: latin1
basedir: "C:/Programme/MySQL/MySQL Server 5.0/"
datadir: "C:/Programme/MySQL/MySQL Server 5.0/Data/"
Creating Windows service entry.
Service Name: "MySQLCust"
Parameters: "C:\Programme\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="C:\mytest.ini" MySQLCust.
Windows service MySQLCust installed.
Service started successfully.
The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: NO)
----------------------------------------
Welcome to the MySQL Server Instance Configuration Wizard 1.0.6
Date: 2005-10-19 21:53:46
Removing Service...
Instance stopped.
Windows Service removed.
Service Name: MySQLCust
Configuration file removed.
Filename: C:\mytest.ini
To use the Instance Configuration Wizard from the command line the following parameters can be used. These parameters have to be set to run from the command line
-n<product name>
-p<path of installation> (no \bin)
-v<version>
Actions to perform
-i (install instance)
-r (remove instance)
-s (stop instance)
-q (be quiet)
-lfilename (write log file)
When launched manually, these can also be submitted
-t<.cnf template filename>
-c<.cnf filename>
Use the following option to define the parameters for the config file generation.
ServiceName=$
AddBinToPath={yes | no}
ServerType={DEVELOPMENT | SERVER | DEDICATED}
DatabaseType={MIXED | INNODB | MYISAM}
ConnectionUsage={DSS | OLTP}
ConnectionCount=#
SkipNetworking={yes | no}
Port=#
StrictMode={yes | no}
Charset=$
RootPassword=$
RootCurrentPassword=$
The return codes of the Wizard in case of an error are.
2 ... Configuration template file cannot be found.
3 ... The Windows service entry cannot be created.
4 ... Could not connect to the Service Control Manager.
5 ... The MySQL service cannot be started.
6 ... The MySQL service cannot be stopped.
7 ... The security settings cannot be applied.
8 ... The configuration file cannot be written.
9 ... The Windows service entry cannot be removed.
Examples:
The following command installs a MySQL Server 5.0 instance from the directory
C:\Programme\MySQL\MySQL Server 5.0 using the service name MySQLCust and settingthe root password to 1234.
MySQLInstanceConfig.exe -i -q "-lC:\mysql_install_log.txt" "-nMySQL Server 5.0"
"-pC:\Programme\MySQL\MySQL Server 5.0" -v5.0.13 "-t..\..\res\my-template.ini" "-cC:\mytest.ini"
ServerType=DEVELOPMENT DatabaseType=MIXED ConnectionUsage=DSS Port=3311
ServiceName=MySQLCust RootPassword=1234
If the server can not be started, the exit code is 2.
The following command removes the server instance with the name MySQLCust.
MySQLInstanceConfig.exe -r -q "-lC:\mysql_install_log.txt" "-nMySQL Server 5.0"
"-pC:\Programme\MySQL\MySQL Server 5.0" -v5.0.13 "-cC:\mytest.ini" ServiceName=MySQLCust
Output into the log file:
----------------------------------------
Welcome to the MySQL Server Instance Configuration Wizard 1.0.6
Date: 2005-10-19 21:53:16
Installing service ...
Product Name: MySQL Server 5.0
Version: 5.0.13
Installation Path: C:\Programme\MySQL\MySQL Server 5.0\
Creating configuration file C:\mytest.ini using template ..\..\res\my-template.ini.
Options:
DEVELOPMENT
MIXED
DSS
STRICTMODE
Variables:
port: 3311
default-character-set: latin1
basedir: "C:/Programme/MySQL/MySQL Server 5.0/"
datadir: "C:/Programme/MySQL/MySQL Server 5.0/Data/"
Creating Windows service entry.
Service Name: "MySQLCust"
Parameters: "C:\Programme\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="C:\mytest.ini" MySQLCust.
Windows service MySQLCust installed.
Service started successfully.
The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: NO)
----------------------------------------
Welcome to the MySQL Server Instance Configuration Wizard 1.0.6
Date: 2005-10-19 21:53:46
Removing Service...
Instance stopped.
Windows Service removed.
Service Name: MySQLCust
Configuration file removed.
Filename: C:\mytest.ini
0 0
- MySQLInstanceConfig 命令详解
- MySQL Server 5.0–安装及配置/MySQLInstanceConfig.exe用法详解
- MySQL Server 5.0–安装及配置/MySQLInstanceConfig.exe用法详解
- MySQL Server 5.0–安装及配置/MySQLInstanceConfig.exe用法详解
- MySQL Server 5.0–安装及配置/MySQLInstanceConfig.exe用法详解
- MySQL Server 5.0–安装及配置/MySQLInstanceConfig.exe用法详解
- dbx 命令命令详解
- MySQL 命令大全 - 命令详解
- [linux命令]tar命令详解
- MySQL 命令集 - 命令详解
- MySQL 命令大全 - 命令详解
- useradd 命令详解 - [命令操作]
- yum命令详解(linux命令)
- MySQL 命令大全 - 命令详解
- MySQL 命令大全 - 命令详解
- MySQL 命令大全 - 命令详解
- yum命令详解(linux命令)
- MySQL 命令大全 - 命令详解
- java中获取时间的一些常用操作
- 在 eclipse 下利用 gradle 构建系统
- 向量内积、矩阵内积以及其性质
- 课程设计:图书管理系统
- QT4(C++)两个头文件相互包含(类超前引用)
- MySQLInstanceConfig 命令详解
- 解析 Linux 中的 VFS 文件系统机制
- LinearLayout(vertical) 的多个布局
- 来自阿里的 json 解析方案 fastjson
- 西门子243模块通信
- 7、对象的转型
- Java编程思想第四版——javadoc的使用细节
- Linux server 杂谈
- JNI学习笔记——创建JAVA对象和内部类需注意