Linux server configuration scheme MySQL_MySQL

MySQL is a multi-user, multi-thread SQL database server. It can be used for relational databases on various popular operating system platforms. it has a distributed database management system with a client server architecture. MySQL is fully applicable to networks. databases built with MySQL can be accessed anywhere on the Internet. MySQL can use the SQL language. SQL (Structured Query Language) is the most MySQL in the world. it is a multi-user, multi-thread SQL database server. It can be used for relational databases on various popular operating system platforms. it has a distributed database management system with a client/server architecture. MySQL is fully applicable to networks. databases built with MySQL can be accessed anywhere on the Internet. MySQL can use the SQL language. SQL (Structured Query Language) is the world's most popular and standardized database language. MySQL is implemented in a client/server structure. it consists of a server daemon mysqld and many different client programs and libraries. SQL is a standardized language that makes it easier to store and update information. MySQL is designed to be fast, robust, and easy to use.
　　
1. install MySQL
　　
Required Resources:
　　
In XteamLinux 4.0, MySQL is installed by default. the version is 3.23.36.
　　
II. upgrade method:
　　
Step 1: rpm-Uvh MySQL package.
Step 2: execute mysql and start MySQL monitor to use mysql database.
　　
III. Use of MySQL
　　
Note: When using a query statement, you must Enter a semicolon (;) at the end of the query statement and press Enter.
　　
Start the MySQL Daemon (XteamLinux 4.0 is disabled by default)
/Etc/rc. d/init. d/mysql start
Disable the MySQL daemon
/Etc/rc. d/init. d/mysql stop
Check the running status of the MySQL server
　　
1. check MySQL attributes
　　
/Usr/bin/mysqladmin variables
　　
2. check the MySQL version/usr/bin/mysqladmin version.
　　
3. check the MySQL running status/usr/bin/mysqladmin status
　　
4. check the running thread information of the MySQL server.
/Usr/bin/mysqladmin processlist
　　
5. check the MySQL status
Mysqladmin ping
　　
6. refresh all tables and rewrite log files
Flush all tables and close and open logfiles
Mysqladmin refresh
　　
4. connect and disconnect the server
　　
1. connect to the server
　　
Mysql-h host-u user-p
# If the service runs on the same machine as MySQL, this option can be omitted.
# Enter a password
　　
2. disconnect the server
　　
Quit
# After entering MySQL, you can press help to obtain help information.
# You can also press [Ctrl + D] to exit.