1 on 1 web hosting - SETTING UP MYSQL AND PHPMYADMIN Assuming everything went
SETTING UP MYSQL AND PHPMYADMIN Assuming everything went well, skip ahead to the section Using MySQL with a graphical interface. If you cannot find mysql and mysqli in the PHP configuration, read on. Troubleshooting You must be able to see the mysql and mysqli entries in the PHP configuration page before attempting to go any further. Without them, you can t connect to MySQL. The most com mon cause for them failing to appear lies in Windows not reading the correct version of php.ini, or not being able to find php.ini at all. This usually happens if you had a previ ous installation of PHP and didn t remove it from the Windows system folders. After run ning phpinfo(), check the value for Configuration File (php.ini) Path (it s the sixth item from the top). If it s pointing to C:WINDOWSphp.ini or C:WINNTphp.ini, you should return to Chapter 2 and follow the advice on removing an old version of PHP. Unfortunately, this doesn t always work, as there may be other programs preventing Windows from reading the correct version of php.ini. If this happens to you, the most practical solu tion is to copy php.ini to C:WINDOWS or C:WINNT (depending on your system). You will probably also need to copy libmysql.dll to C:WINDOWSsystem32 or C:WINNTsystem32. Setting up MySQL on Mac OS X MySQL is available as a Mac PKG file, so everything is taken care of for you, apart from some minor configuration. Downloading and installing MySQL When upgrading an existing installation of MySQL, the Mac installer will not move your data files. You must first create a backup, as described at the end of this chapter, and reload them after upgrading. You must also shut down the MySQL server. If you have never installed MySQL before, you don t need any special preparations; just follow these instructions. 1. Go to www.mysql.com/downloads, and select the link for the Current Release (Recommended) of MySQL Community Edition Database Server and Client. MySQL 5 is not supported on Jaguar (OS X 10.2). Download the most recent ver- sion of MySQL 4.1 instead. It should be listed among Older Releases or Archives. 271
If you are looking for affordable and reliable webhost to host and run your business application visit our ftp web hosting services.