有2个方法 一、可以修改my.ini 配置参数(linux下面是 my.cnf); [quote][client] port=3306 default-character-set=utf8 host=localhost user=root password=1[/quote] 具体的其他参数都可以在这里修改 二、可以修改环境
有2个方法 一、可以修改my.ini 配置参数(linux下面是 my.cnf); [quote][client] port=3306 default-character-set=utf8 host=localhost user=root password=1[/quote] 具体的其他参数都可以在这里修改 二、可以修改环境变量 MYSQL_HOST 代表主机名 USER 为用户名 MYSQL_PWD 为密码 更多的参数请自行查看mysql的帮助文档，下面是英文的表格
|
| Variable |
Description |
| CXX |
The name of your C++ compiler (for running configure ). |
| CC |
The name of your C compiler (for running configure ). |
| CFLAGS |
Flags for your C compiler (for running configure ). |
| CXXFLAGS |
Flags for your C++ compiler (for running configure ). |
| DBI_USER |
The default user name for Perl DBI. |
| DBI_TRACE |
Trace options for Perl DBI. |
| HOME |
The default path for the mysql history file is $HOME/.mysql_history . |
| LD_RUN_PATH |
Used to specify the location of libmysqlclient.so . |
| MYSQL_DEBUG |
Debug trace options when debugging. |
| MYSQL_GROUP_SUFFIX |
Option group suffix value (like specifying --defaults-group-suffix ). |
| MYSQL_HISTFILE |
The path to the mysql history file. If this variable is set, its value overrides the default for $HOME/.mysql_history . |
| MYSQL_HOME |
The path to the directory in which the server-specific my.cnf file resides (as of MySQL 5.0.3). |
| MYSQL_HOST |
The default host name used by the mysql command-line client. |
| MYSQL_PS1 |
The command prompt to use in the mysql command-line client. |
| MYSQL_PWD |
The default password when connecting to mysqld . Note that using this is insecure. See Section 5.5.6.2, “End-User Guidelines for Password Security”. |
| MYSQL_TCP_PORT |
The default TCP/IP port number. |
| MYSQL_UNIX_PORT |
The default Unix socket file name; used for connections to localhost . |
| PATH |
Used by the shell to find MySQL programs. |
| TMPDIR |
The directory where temporary files are created. |
| TZ |
This should be set to your local time zone. See Section B.1.4.6, “Time Zone Problems”. |
| UMASK |
The user-file creation mode when creating files. See note following table. |
| UMASK_DIR |
The user-directory creation mode when creating directories. See note following table. |
| USER |
The default user name on Windows and NetWare used when connecting to mysqld . |
