SETTING UP MYSQL AND PHPMYADMIN phpMyAdmin, which is (Web site domain)
SETTING UP MYSQL AND PHPMYADMIN phpMyAdmin, which is free and the default method many hosting companies provide for accessing MySQL. This chapter shows you how to install both of them. Which version? MySQL and phpMyAdmin release new versions at a fast-and-furious pace. While this means that new features become available as soon as they re developed, and bugs get squashed quickly, hosting companies rarely keep pace. In fact, many hosting companies are still running the MySQL 3.23 series an excellent database, even though it is two major versions behind the current release. Rather than attempting to find old versions to match the setup on your hosting company, I recommend that you install the latest stable version of both MySQL and phpMyAdmin. That way, you will find it easier to get help if you run into difficulties. Wherever possible, I have designed the code in this book to be backward compatible with MySQL 3.23, and I point out anything that isn t. You can get MySQL from the downloads page at http://dev.mysql.com/downloads. Select the link for the Current Release (Recommended) of MySQL Community Edition Database Server and Client. 10 The installation instructions for MySQL are different for Windows and Mac OS X, so Mac users should skip ahead to the relevant section of the chapter. Because new versions are coming out all the time, I recommend that you check my web- site at http://foundationphp.com/phpsolutions/updates.php before going ahead. Any major updates to the instructions will be listed there. Installing MySQL on Windows MySQL comes in a range of versions, but the one you should choose is Windows Essentials. It contains all the important stuff, and certainly everything you need for this book. If you have a version older than MySQL 4.1.5 already installed on your computer, you must uninstall the old version first. 263
You need excellent and relaible webhost company to host your web applications? Then pay a visit to Inexpensive Web Hosting services.