SETTING UP MYSQL AND PHPMYADMIN 10. The actual
SETTING UP MYSQL AND PHPMYADMIN 10. The actual installation now takes place and is normally very quick. When everything s finished, you re presented with a final dialog box. If this is a new installation or if you are upgrading from one series to another, click Finish to launch the Configuration Wizard, which is described in the next section. If you are upgrading to a later version of the same series (such as from 5.0.10 to 5.0.24), deselect the check box labeled Configure the MySQL Server now before clicking Finish. MySQL should be ready to use, but needs to be restarted manually (see Starting and stopping MySQL manually on Windows later in the chapter). If you have a software firewall, you might also be prompted to allow connections to and from MySQL. Configuring MySQL Windows Essentials There are a lot of dialog boxes to go through, although all you usually need to do is accept the default setting. These instructions are based on version 1.0.8 of the Configuration Wizard. 1. The Configuration Wizard opens with a welcome screen. Click Next to proceed. 2. The first dialog box asks whether you want a detailed or standard configuration. Choose the default Detailed Configuration option and click Next. 3. The three options on the next screen affect the amount of computer resources devoted to MySQL. Accept the default Developer Machine and click Next. If you choose either of the other options, all other programs will slow down to a crawl. 4. The next dialog box asks you to select from the following three types of database: Multifunctional Database: Allows you to use both InnoDB and MyISAM tables. Transactional Database Only: InnoDB tables only. MyISAM is disabled. Non-Transactional Database Only: MyISAM tables only. InnoDB is disabled. Most hosting companies support only MyISAM tables, so choose Non-Transactional Database Only. Unless you plan to learn MySQL in depth, there is little advantage in choosing Multifunctional Database, which requires an extra 30MB of disk space. If you choose Multifunctional Database, you need to edit the MySQL configuration file later, as described in Changing the default table type on Windows Essentials. 5. What you see next may vary. If you chose Non-Transactional Database Only in the preceding step, you should be taken directly to step 6. However, you may see a dialog box inviting you to select a drive for the InnoDB data file. Unless you chose Multifunctional Database, just click Next and move on to step 6. 265
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.