Learning Mysql

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 Onto 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 Figure.
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- directory,
where 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.

Download 4.24 Mb.

Share with your friends: