Home arrow MySQL arrow MySQL Database Administration

MySQL Database Administration

If you need to administer MySQL, this article gets you off to a good start. The first of a multi-part series, it is excerpted from chapter four of the book MySQL Administrator's Guide, written by Paul Dubois (Sams; ISBN: 0672326345).

TABLE OF CONTENTS:
  1. MySQL Database Administration
  2. 4.1.2 The mysqld-max Extended MySQL Server
  3. 4.1.3 The mysqld_safe Server Startup Script
  4. 4.1.4 The mysql.server Server Startup Script
  5. 4.2 Configuring the MySQL Server
  6. 4.2.2 The Server SQL Mode
  7. 4.2.3 Server System Variables
By: Sams Publishing
Rating: starstarstarstarstar / 28
May 25, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement
Chapter 4: Database Administratio

This chapter covers topics that deal with administering a MySQL installation, such as configuring the server, managing user accounts, and performing backups.

4.1 The MySQL Server and Server Startup Scripts

The MySQL server, mysqld, is the main program that does most of the work in a MySQL installation. The server is accompanied by several related scripts that perform setup operations when you install MySQL or that are helper programs to assist you in starting and stopping the server.

This section provides an overview of the server and related programs, and information about server startup scripts. Information about configuring the server itself is given in Section 4.2, "Configuring the MySQL Server."

4.1.1 Overview of the Server-Side Scripts and Utilities

All MySQL programs take many different options. However, every MySQL program provides a --help option that you can use to get a description of the program's options. For example, try mysqld --help.

You can override default options for all standard programs by specifying options on the command line or in an option file. See Section 3.3, "Specifying Program Options."

The following list briefly describes the MySQL server and server-related programs:

  • mysqld

    The SQL daemon (that is, the MySQL server). To use client programs, this program must be running, because clients gain access to databases by connecting to the server. See Section 4.2, "Configuring the MySQL Server."

  • mysqld-max

    A version of the server that includes additional features. See Section 4.1.2, "The mysqld-max Extended MySQL Server."

  • mysqld_safe

    A server startup script. mysqld_safe attempts to start mysqld-max if it exists, and mysqld otherwise. See Section 4.1.3, "The mysqld_safe Server Startup Script."

  • mysql.server

    A server startup script. This script is used on systems that use run directories containing scripts that start system services for particular run levels. It invokes mysqld_safe to start the MySQL server. See Section 4.1.4, "The mysql.server Server Startup Script."

  • mysqld_multi

    A server startup script that can start or stop multiple servers installed on the system. See Section 4.1.5, "The mysqld_multi Program for Managing Multiple MySQL Servers."

  • mysql_install_db

    This script creates the MySQL grant tables with default privileges. It is usually executed only once, when first installing MySQL on a system.

  • mysql_fix_privilege_tables

    This script is used after an upgrade install operation, to update the grant tables with any changes that have been made in newer versions of MySQL.

There are several other programs that also are run on the server host:

  • myisamchk

    A utility to describe, check, optimize, and repair MyISAM tables. myisamchk is described in Section 4.6.2, "Table Maintenance and Crash Recovery."

  • make_binary_distribution

    This program makes a binary release of a compiled MySQL. This could be sent by FTP to /pub/mysql/upload on ftp.mysql.com for the convenience of other MySQL users.

  • mysqlbug

    The MySQL bug reporting script. It can be used to send a bug report to the MySQL mailing list. (You can also visit http://bugs.mysql.com/ to file a bug report online.)



 
 
>>> More MySQL Articles          >>> More By Sams Publishing
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: