Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Common Options of the MySQL Client Tools

-u un           --user=username                      Determines the user name for registration with MySQL. -p              --password                           Asks for input of password immediately after start of the command. -pxxx           --password=xxx                       Passes the password directly -h hn           --host=hostname                      Gives the name or IP number of the computer on which the server is running.                 --protocol=name                      Determines which protocol should be used for communication between client and server.  -W              --pipe                               Uses a named pipe for communication with the MySQL server.  -C              --compress                           Minimizes the data flow between client and server by making use of data compression.                 --default-character-set=name         Specifies the character set for communication with the MySQL server (e.g., latin1 or utf8).                 --character-sets-dir="dir"           Specifies the directory in which the character set files are located (e.g., "C:/Programs/MySQL/MySQL Server 5.0/share/charsets").