MySQL

General Administration

General administration deals primarily with the operation of mysqld, the MySQL server, and in providing your users with access to the server. In carrying out this responsibility, the following duties are the most important:

• Server startup and shutdown. You should be able to start and stop the server manually from the command line and know how to arrange for automatic startup and shutdown when your system starts up and shuts down. It's also important to know what to do to get the server going again if it crashes or will not start properly.

• User account maintenance. You should understand the difference between MySQL users and UNIX or Windows users. You should know how to set up MySQL user accounts by specifying which users ...