Linux server configuration scheme MySQL (on)

MySQL is a multi-user, multi-threaded SQL database server. A relational database that can be used in a variety of popular operating system platforms, with a distributed database management system for client/server architecture. MySQL is perfectly suited for the web, and databases built with it can be accessed from anywhere on the web. MySQL can use the SQL language. SQL (Structured Query Language) is the world's most popular and standardized database language. MySQL is a client/server architecture implementation consisting of a server daemon, mysqld, and many different clients and libraries. SQL is a standardized language that makes it easier to store and update information. The main goal of MySQL is fast, robust and easy to use.

MySQL installation

Resources required:

In XteamLinux 4.0, MySQL has been installed by default, the version number is: 3.23.36.

Upgrade Method:

Step 1: rpm -Uvh MySQL package.

Step 2: Execute mysql, start MySQL monitor and you can use mysql database.

MySQL Usage

Note: When using a query, you need to type a semicolon (;) at the end of the query and press Enter.

Starting the MySQL daemon (XteamLinux 4.0 is not enabled by default)

/etc/rc.d/init.d/mysql start

Shutting down the MySQL daemon

/etc/rc.d/init.d/mysql stop

Checking the MySQL server operation

1. Checking the properties of MySQL

/usr /bin/mysqladmin variables 2. Check the MySQL version information /usr/bin/mysqladmin version

3. Check the MySQL running status /usr/bin/mysqladmin status

4. Check the MySQL server. Thread information that is running

/usr/bin/mysqladmin processlist

5. Check the status of MySQL

mysqladmin ping

6. Refresh all Table and rewrite log files

Flush all tables and close and open logfiles

mysqladmin refresh

Connect and disconnect servers

1. Connect to server< Br>

mysql -h host -u user -p

# If this service is running on the same machine as MySQL, this option can be omitted.

#要求输入密码

2, disconnect the server

quit

# After entering MySQL, you can type help to get help information

#also type [Ctrl+D] to exit