After you’ve finished installing MySQL on your server, you should perform a few tasks before allowing others to begin using the service. You may want to configure the server differently by making changes to the configuration file. At a minimum, you should change the password for the root user and add some nonadministrative users. Some versions of MySQL are initially set up with anonymous users. You should delete them. This section will briefly explain these tasks.
Although the MySQL developers have set the server daemon to the
recommended configuration, you may want to set the daemon differently. For
instance, you may want to turn on error logging. To do this, you will need to edit the main
configuration file for MySQL. On Unix systems, this file is /etc/my.cnf.
On Windows systems, the main configuration file is usually either
c:\windows\my.ini or c:\my.cnf.
The configuration file is a simple text file that you can edit with a
plain-text editor, not a word processor. The configuration file is
organized into sections or groups under a heading name contained in square
brackets. For instance, settings for the server daemon
mysqld are listed under the group heading
[mysqld]. Under this heading, you could add something
log = /var/log/mysql to enable logging and to set
the directory for the log files to the one given. You can list many
options in the file for a particular group. For a complete listing and
explanation of these options, see Chapter 15.
You can change ...