7.6 mysqlcc, the MySQL Control Center

7.6 mysqlcc , the MySQL Control Center

mysqlcc , the MySQL Control Center, is a platform-independent client that provides a graphical user interface (GUI) to the MySQL database server. It supports interactive use, including syntax highlighting and tab completion. It provides database and table management, and allows server administration.

mysqlcc is not included with MySQL distributions, but can be downloaded separately at http://dev.mysql.com/downloads/. Currently, mysqlcc runs on Windows and Linux platforms.

Invoke mysqlcc by double-clicking its icon in a graphical environment. From the command line, invoke it like this:

 shell>  mysqlcc  [  options  ] 

mysqlcc supports the following options:

• --help , -?

  Display a help message and exit.

• --blocking_queries , -b

  Use blocking queries.

• --compress , -C

  Compress all information sent between the client and the server if both support compression.

• --connection_name= name , -c name

  This option is a synonym for --server .

• --database= db_name , -d db_name

  The database to use. This is useful mainly in an option file.

• --history_size= # , -H #

  The history size for the query window.

• --host= host_name , -h host_name

  Connect to the MySQL server on the given host.

• --local-infile[={01}]

  Enable or disable LOCAL capability for LOAD DATA INFILE . With no value, the option enables LOCAL . It may be given as --local-infile=0 or --local-infile=1 to explicitly disable or enable LOCAL . Enabling LOCAL has no effect if the server does not also support it.

• --password[= password ] , -p[ password ]

  The password to use when connecting to the server. Note that if you use the short option form ( -p ), you cannot have a space between the option and the password. If no password is given on the command line, you will be prompted for one.

• --plugins_path= name , -g name

  The path to the directory where MySQL Control Center plugins are located.

• --port= port_num , -P port_num

  The TCP/IP port number to use for the connection.

• --query , -q

  Open a query window on startup.

• --register , -r

  Open the Register Server dialog on startup.

• --server= name , -s name

  The MySQL Control Center connection name.

• --socket= path , -S path

  The socket file to use for the connection.

• --syntax , -y

  Enable syntax highlighting and completion.

• --syntax_file= name , -Y name

  The syntax file for completion.

• --translations_path= name , -T name

  The path to the directory where MySQL Control Center translations are located.

• --user= user_name , -u user_name

  The MySQL username to use when connecting to the server.

• --version , -V

  Display version information and exit.

You can also set the following variables by using -- var_name = value options:

• connect_timeout

  The number of seconds before connection timeout. (Default value is 0.)

• max_allowed_packet

  The maximum packet length to send to or receive from the server. (Default value is 16MB.)

• max_join_size

  The automatic limit for rows in a join. (Default value is 1,000,000.)

• net_buffer_length

  The buffer size for TCP/IP and socket communication. (Default value is 16KB.)

• select_limit

  The automatic limit for SELECT statements. (Default value is 1,000.)

It is also possible to set variables by using -- set-variable = var_name = value or -O var_name = value syntax. However, this syntax is deprecated as of MySQL 4.0.