home support FAQ resources services partners contact us contact us
 MySQL Tutorial Previous  Next  
 

You may not need to supply all those options when you invoke mysql, but it's likely that you'll have to specify at least a name and password. Here's what the options mean:

-h host_name (alternate form: --host=host_name)

The server host you want to connect to. If the MySQL server is running on the same machine where you are running mysql, this option normally can be omitted.

-u user_name (alternate form: --user=user_name)

Your MySQL username. If you're using UNIX and your MySQL username is the same as your login name, you can omit this option; mysql will use your login name as your MySQL name.

Under Windows, the default user name is ODBC, which is unlikely to be a useful default for you. Either specify a -u option on the command line or add a default to your environment by setting the USER variable. For example, you can use the following set command to specify a user name of sampadm:

C:\> set USER=sampadm

If you place this command in your AUTOEXEC.BAT file, it will take effect whenever you start up Windows and you won't have to issue it at the prompt.

-p (alternate form: --password)
Previous  Next  
Link Partners: Asia florist, Flowers to India, Hong kong flowers, Site submit, Cheap web hosting, China florist, Japan florist