The MySQL Package
The MySQL package comes with several programs. Foremost is the MySQL server, represented by the mysqld daemon. The daemon listens for requests on a particular network port (3306 by default) by which clients submit queries. The standard MySQL client program is simply called mysql. With this text-based interface, a user can log in and execute SQL queries. This client can also accept queries from text files containing queries, and thereby execute them on behalf of the user or other software. However, most MySQL interaction is done by programs using a variety of languages. The interfaces for C, Perl, and PHP are discussed in this book.
A few wrapper scripts for mysqld come with
MySQL. The mysqld_safe
script is the most common way to start
mysqld, because the script can restart the daemon if
it crashes. This helps ensure minimal downtime for database services. The
script mysqld_multi
is used to start multiple sessions
of mysqld_safe
, and thereby multiple
mysqld instances, for handling requests from
different ports, and to make it easier to serve different sets of
databases or to test different versions of MySQL.
MySQL also comes with a variety of utilities for managing a MySQL
server. mysqlaccess
is used for creating user accounts and setting their privileges. mysqladmin
can be used to manage the MySQL
server itself from the command line. This interaction includes checking a
server’s status and usage, and shutting down a server.
mysqlshow
may be used to examine a server’s status, as
well as information about databases and tables. Some of these utilities
require Perl, or ActivePerl for Windows, to be installed on the server.
See http://www.perl.org to download and install a
copy of Perl on non-Windows systems, and see http://www.activestate.com/Products/ActivePerl to download
and install a copy of ActivePerl on Windows systems.
MySQL also comes with a few utilities for importing and exporting
data to and from MySQL databases. mysqldump
is
the most popular for exporting data and table structures to
a plain-text file known as a dump file. This can be
used for backing up data or for manually moving it between servers. The
mysql
client can be used to import the data back to
MySQL from a dump file. See Chapter 16 for more on
utilities.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.