Chapter 8 . Command Line Interface (CLI) 139 Figure 8-7: Specifying the password immediately following the -p switch prevents the CLI from prompting for a password. Figure 8-8: The syntax for the –password switch is slightly different from the -p switch. The password=
switch can be added into the MySQL configuration file and thus saved between sessions. This is also a security risk. Alternatively, you could simply place the word password under the [mysql] section of the configuration file and you are prompted for the password just as if you used the -p switch. (See this chapter s MySQL CLI Environment Variables section for more about working with CLI variables.) Specifying the host In much the same way that MySQL uses the current user if the -uswitch is not used, not using the -h switch makes MySQL assume you mean to connect to the server on the localhost (the current machine). If you want to connect to a MySQL server on another machine, you can specify the IP address or hostname of the other MySQL server via the -hswitch, as shown in Figure 8-9.
Note: If you are looking for best quality webspace to host and run your tomcat application check Vision personal web hosting services
This entry was posted
on Sunday, April 29th, 2007 at 6:01 am and is filed under Domain.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.