There are 2 methods
1. You can modify the configuration parameters of my. ini (My. CnF in Linux );
[Quote] [client]
Port = 3306
Default-character-set = utf8
Host = localhost
User = root
Password = 1 [/quote]
You can modify other parameters here.
2. You can modify environment variables.
Mysql_host represents the Host Name
User is the user name
Mysql_pwd is the password
For more parameters, see the MySQL help documentation. The following is a table in English.
Variable |
Description |
Cxx |
The name of your c ++ Compiler (for runningConfigure). |
CC |
The name of your C compiler (for runningConfigure). |
Cflags |
Flags for your C compiler (for runningConfigure). |
Cxxflags |
Flags for your c ++ Compiler (for runningConfigure). |
Dbi_user |
The Default User Name For Perl DBI. |
Dbi_trace |
Trace options for Perl DBI. |
Home |
The default path forMySQLHistory file is$ Home/. mysql_history . |
Ld_run_path |
Used to specify the locationLibmysqlclient. So . |
Mysql_debug |
Debug trace options when debugging. |
Mysql_group_suffix |
Option group suffix value (like specifying-- Defaults-group-suffix ). |
Mysql_histfile |
The path toMySQLHistory file. If this variable is set, its value overrides the default$ Home/. mysql_history . |
Mysql_home |
The path to the directory in which the server-specificMy. CNF File resides (as of MySQL 5.0.3 ). |
Mysql_host |
The default host name used byMySQLCommand-line client. |
Mysql_ps1 |
The command prompt to use inMySQLCommand-line client. |
Mysql_pwd |
The default password when connectingMysqld. 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 connectionsLocalhost . |
Path |
Used by the shell to find MySQL programs. |
Tmpdir |
The directory where temporary files are created. |
TZ |
This shoshould 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 . |