Web server - PHP SOLUTIONS: DYNAMIC WEB DESIGN MADE EASY Installing
PHP SOLUTIONS: DYNAMIC WEB DESIGN MADE EASY Installing the Windows Essentials version of MySQL These instructions are based on the 5.0 series of MySQL, which is installed in C:Program FilesMySQLMySQL Server 5.0. I expect MySQL 5.1 to become the rec- ommended release shortly after publication of this book. On past experience, the default location changes for each series of Windows Essentials, so 5.1 is likely to be installed in C:Program FilesMySQLMySQL Server 5.1, and Windows treats different series as completely separate programs. If you upgrade from one series to another, any existing databases need to be transferred to the new version as if it were a different server (see the section titled Backup and data transfer near the end of this chapter). 1. Go to the MySQL download site and select the link for the current release. 2. In the page that opens, scroll down to find the section marked Windows downloads. There is a separate Windows x64 downloads section for 64-bit versions of Windows. Choose Windows Essentials from the appropriate section, and click the download link. (You may be invited to Pick a mirror instead. This directs you to a mirror site closer to your location, and usually offers a faster download.) 3. Download the MySQL file to your hard disk. It will have a name like mysqlessential-x.x.x-win32.msi, where x.x.x represents the version number. The 64-bit version is called mysql-essential-x.x.x-win64.msi. Make sure you have the correct version. 4. Exit all other Windows programs, and double-click the icon of the file you have just downloaded. This is a self-extracting Windows Installer package. 5. Windows Installer will begin the installation process and open a welcome dialog box. If you are upgrading an existing version of the same series of Windows Essentials to a more recent one, the dialog box will inform you that it has detected your current installation and will remove it before installing the new one. However, all your databases will remain intact. Click Next to continue. 6. Another dialog box may give you the opportunity to change the installation destination. Accept the default and click Next. 7. In the next dialog box, accept the default setup (Typical) and click Next. 8. If you re happy to go ahead with installation, click Install in the next dialog box. 9. Before launching into the actual installation, MySQL invites you to sign up for a free MySQL.com account. I suggest that you select Skip Sign-Up and click Next. After you finish setting everything up, visit www.mysql.com/register.php to see if you re interested in the benefits offered. The main advantage is that you get automatic notification of new versions and links to helpful articles about new features of MySQL.
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.