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. MySQL is 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:\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
this heading you could add something like
/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 10.
You can change the password for the ...