Installing MySQL - Learning MySQL - page 61

You can also configure the server password, as well as other settings for better security,
by loading http://localhost in your browser and clicking on the Security link on the left
of the page. This takes you to a page that displays information on your server security
configuration and allows you to add passwords to authenticate access to the MySQL
and Apache servers.
The XAMPP installation has PHP configured, with the register_globals setting turned
on. You should disable this old, insecure feature: open the file C:\Program Files
\xampp \ php\php.ini and look for the line register_globals = On . Change the value On
to Off , save the file, and quit the editor. The new setting will be in effect after you restart
your Apache server.
Finally, you can stop the MySQL server by pressing the Stop button next to the MySQL
label in the XAMPP control panel.
Installing Under Mac OS X
In this section, we'll look at three ways to install MySQL on a Mac OS X system:
• System-wide, using an installation package provided by MySQL AB.
• Local, using an non-installation gzipped tar package provided by MySQL AB.
• System-wide, using the XAMPP integrated package.
To install system-wide, you should be able to access superuser privileges through the
sudo command.
Installing only MySQL Using the Installer from MySQL AB
Following the instructions of “Downloading MySQL from the MySQL AB Web Site,”
earlier in this chapter, visit the MySQL AB downloads page and choose the package
corresponding to the version of your operating system and your system processor.
Pick the Standard installer (rather than TAR) package. This is a small package that has
everything you need. Once the file is downloaded, double-click on it to unpack the
archive and view the package contents. You should see something similar to Fig-
ure 2-17.
Double-click on the package file with a name beginning with mysql-standard- to start
the installation process.
Simply following the prompts will install to the /usr/local/mysql-<version> directory,
where <version> is the MySQL version number. It also creates the symbolic link (or
alias) /usr/local/mysql that points to this installation directory. For example, the files
could be installed in the /usr/local/mysql-5.0.22 directory, and the /usr/local/mysql
link set to point to this directory.