SETTING UP (Email web hosting) MYSQL AND PHPMYADMIN Using MySQL with
SETTING UP MYSQL AND PHPMYADMIN Using MySQL with a graphical interface Although you can do everything using MySQL monitor, it s a lot easier to use a graphic interface. There are several to choose from, both commercial and free. Among the free offerings are two from MySQL itself: MySQL Administrator and MySQL Query Browser (www.mysql.com/products/tools). Two other popular graphical front ends for MySQL are the commercial product, Navicat (www.navicat.com), and SQLyog (www.webyog.com), which is available in both commercial and free versions. However, the most popular graphical interface for MySQL is phpMyAdmin (www.phpmyadmin. net). It s a PHP-based administrative system for MySQL that has been around since 1998, and it constantly evolves to keep pace with MySQL developments. It works on Windows, Mac OS X, and Linux and currently supports all versions of MySQL from 3.23.32 to 5.0. What s more, many hosting companies provide it as the standard interface to MySQL. Because phpMyAdmin has a very intuitive interface, I suggest that you try it first. If you work with databases on a regular basis, you may want to explore the other graphical interfaces later. However, since phpMyAdmin is free, you have nothing to lose and you may find it does everything you want. Setting up phpMyAdmin on Windows and Mac Since phpMyAdmin is PHP-based, all that s needed to install it is download the files, unzip them to a website in your local testing environment, and create a simple configuration file. Downloading and installing phpMyAdmin 1. Go to www.phpmyadmin.net and download the latest stable version. The files can be downloaded in three types of compressed file: BZIP2, GZIP, and ZIP. Choose whichever format you have the decompression software for. 2. Unzip the downloaded file. It will extract the contents to a folder called phpMyAdmin-x.x.x, where x represents the version number. 3. Highlight the folder icon and cut it to your clipboard. On Windows, paste it inside the folder designated as your web server root (C:htdocs, if you followed my example). If you re on a Mac and want phpMyAdmin to be available to all users, put the folder in Macintosh HD:Library:WebServer:Documents, rather than in your own Sites folder. 4. Rename the folder you have just moved to this: phpMyAdmin. 5. Like Apache and PHP, phpMyAdmin uses a text file to store all the configuration details. Since version 2.7.0, you no longer edit the phpMyAdmin configuration file, but store your personal details in a new file, which should be named config.inc.php. There are two ways of doing this: using a built-in script called setup.php or manually. I prefer the manual method, but instructions for both methods follow. 277
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.