Web proxy server
Chapter 8 . Command Line Interface (CLI) 141 Figure 8-10: Using the CLI and specifying a database from within the CLI MySQL CLI Environment Variables Regardless of whether you use the CLI in interactive mode, variables are available to control how the CLI operates. When read from configuration files, those variables can be set globally with the use of configuration files in particular, my.cnf or my.ini(usually located in the /etcor /usr/local Linux directory or the WINNT directory in Windows 2000). If you want to set the variables on a per-user basis, a .my.cnf file in each user s home directory can provide customized individual use of the MySQL CLI. Make sure that a dot (.) immediately precedes each user s .my.cnf filename for example, .my.cnf. Since the configuration file can reside in each user s home directory, it is only applied when logged in as that user. Determining and changing default variables To determine the variables the MySQL CLI uses for a particular session, use the –print-defaults switch, as shown in Figure 8-11. Changing a default variable is as simple as editing the configuration file. For example, if I want to change the socket that MySQL connects through from the default /tmp/mysql.sock, I could make a .my.cnf file (as shown in Figure 8-12) and include a section for the MySQL CLI in brackets with the socket option underneath. Note
Note: In case you are looking for affordable webhost to host and run your servlet application check Vision make web site services