MySQL培训1(培训教程).ppt

* RHEL Clustering Storage Management page:* MySQL Server MySQL Server, or mysqld, is the database server program The server manages access to the actual databases on disk and in memory MySQL Server is multi-threaded and supports many simultaneous client connections Clients can connect via several connection protocols * RHEL Clustering Storage Management page:* Client programs For communicating with the server to manipulate the information in the databases that the server manages MySQL AB provides several client programs. The following list describes a few of them: MySQL Workbench and MySQL Administrator are graphical front ends to the server mysql is a command-line program that acts as a text-based front end for the server. Its used for issuing queries and viewing the results interactively from a terminal window Other command-line clients include mysqlimport for importing data files, mysqldump for making backups, mysqladmin for server administration, and mysqlcheck for checking the integrity of the database files * RHEL Clustering Storage Management page:* MySQL non-client utilities These are programs that act independently of the server. They do not operate by first establishing a connection to the server. myisamchk is an example. It performs table checking and repair operations. Another program in this category is myisampack, which creates compressed read-only versions of MyISAM tables. Both utilities operate by accessing MyISAM table files directly, independent of the mysqld database server. * RHEL Clustering Storage Management page:* Accessing mysqld with Command-Line Tools These tools include mysql, mysqladmin, and mysqlshow Though each tool performs different functions, they have several common options Often these options will have a long form and a short form Help option -? -I --help * RHEL Clustering Storage Management page:* Common Options Options for MySQL User Identification Options for Establishing a Connection * RHEL Clustering