MySQL client environment variable program Introduction

Source: Internet
Author: User

What are the environment variables of MySQL customers? This is a problem that many people have mentioned. The following describes the MySQL client environment variable program in detail, hoping that you can learn more about MySQL client environment variables.

All MySQL customers who use the mysqlclient Client client to communicate with the server use the following environment variables:

"Mysql" uses the file named in the environment variable MYSQL_HISTFILE to save the command line history. The default value of the historical file is "$ HOME /. mysql_history ", here $ HOME is the value of the HOME environment variable.

All MySQL programs take many different options. However, each MySQL program provides a -- help option, which you can use to get a complete description of different options of the program. For example, try mysql -- help.

You can use an option file to override the default options of all standard customer programs. See 4.15.4 select a file.

The following table briefly describes the MySQL program:

Myisamchk

Describes, checks, optimizes, and fixes MySQL table applications. Because myisamchk has many features, it is described in its own chapter. See 13 maintain MySQL installation.

Make_binary_release

Compile a binary version of MySQL. This can be transmitted over FTP to "/pub/mysql/Incoming" on the ftp. tcx. se website to facilitate other MySQL users.

Msql2mysql

A shell script to convert the mSQL program to MySQL. It cannot handle all the situations, but it provides a good starting point for conversion.

Mysql

Mysql is a simple SQL shell (with GNU readline capability) that supports interactive and non-interactive use. When used in interactive locations, the query results are displayed in the ASCII table format. When used in non-interactive mode (for example, as a filter), the result is expressed in a format separated by positioning characters. You can use the command line option to change the output format. You can simply run the script as follows:

Shell> mysql database <script. SQL> output. tab

If you are experiencing problems due to insufficient memory, use the -- quick option! This forces mysql to use mysql_use_result () instead of mysql_store_result () to retrieve the result set.

Mysqlaccess

A script that checks the access permissions on the host, user, and database combinations.

Mysqladmin

A Management Utility, such as creating or abandoning a database, loading an authorization table, cleaning the table to a disk, and opening a log file. Mysqladmin can also be used to retrieve version, process, and status information from the server. See 12.2 manage a MySQL server.

Mysqlbug

MySQL Error Report script. This script should always be used when you fill in an error report to the MySQL mail list.

Mysqld

SQL daemon. It should be running all the time.

Mysqldump

Text Files separated by SQL statements or delimiters dump a MySQL database into a file. This is the first enhanced version of the Free Software written by Igor Romanenko. See section 12.3 dumping structure and data from MySQL Databases and tables.

Mysqlimport

Use load data infile to import text files to their respective tables. See section 12.4 import data from a text file.

Mysqlshow

Displays information about databases, tables, columns, and indexes.

Mysql_install_db

Create a MySQL authorization table with the default permission. This is usually executed only once. It is the first time MySQL is installed on the system.

Replace

A utility used by msql2mysql, but has more general applicability. Replace changes the strings in the file or standard input. A finite state machine first matches a longer string and can be used to exchange strings. For example, this command exchanges a and B in a given file:

Shell> replace a B a -- file1 file2...

Safe_mysqld

A script that uses some safer features to start the mysqld daemon. For example, when an error occurs, restart the server and record the running time information to a log file.

MySQL declare statement usage

Top 10 most noteworthy MySQL Variables

Application of MySQL System Variables

Take you to understand MySQL random string functions

In-depth study of MySQL result strings

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.