Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Appendix B. Using MySQL for Exercises
Use the following instructions if you will be installing MySQL on a computer with Linux. Note that steps 16 may vary according to the format of the www.mysql.com Web site and the version of MySQL.
MySQL provides both RPM and Zip files for the MySQL installation on Linux, depending on the platform. The recommended installation method for MySQL on Linux is to use the RPM files. However, Zip files are available for certain installations of Linux. Please refer to the MySQL online documentation to determine the best installation method for your version of Linux.
If you have Red Hat Linux 7.1, MySQL should already be included with Linux.
Go to www.mysql.com to download MySQL.
Select downloads from the main menu.
Select the latest stable version, currently MySQL 3.23.
Review the provided information about version 3.23.
Find the appropriate Linux download for your system, then click on the Download selection. More than likely, you will need to download and install the following file: MySQL-client-VERSION.i386.rpm.
Select a mirror site for download that is close to your location. Save the file to your computer.
Copy the file MySQL-client-VERSION.i386.rpm to your Linux computer.
Execute the following command as root to install MySQL. This is the standard minimal installation. If you are new to Linux, it is best practice to log in as a non-root user, and then use the su command to switch to the user root.
After installation, MySQL data should be located in /var/lib/mysql. The exact location may vary according to platform and version of MySQL. Please verify this information with the applicable documentation for MySQL.
Once MySQL is successfully installed, test the software installation by following the instructions in the post-installation portion of the online documentation.
If all the above steps were successful, you are ready to use MySQL for exercises in this book.
If you experience problems during the installation, uninstall MySQL and repeat the previous steps. If you are still unable to obtain or install MySQL, contact MySQL for support.
MySQL is also available for MacOS and most other versions of Unix.