MySQL with Apache server and PHP5. Download mysql-5.5.11-win32 from http://www.mysql.com/downloads/mysql/ Configure Apache Server And PHP5 on your computer system as given at http://themissingnotes.wordpress.com/201 1/09/20/configuring-php-with-apache- server-on-windows-xp/ . Click on mysql-5.5.11-win32 to start installation wizard. After agreeing on the End-user agreement, Click on Typical button as Setup Type. Next click to start Installation. During installation, you will require to include MySQL Enterprise which includes services to help create your database or try some examples with already prepared examples. Click Next. Next, MySQL Enterprise Monitor Service lets you access the performance metrics of your code across all your servers. This helps to optimize your code in case you are building database intensive application. This finishes the primary installation. See the checkbox at the bottom. It should be checked to start configuring the server for use on your computer. Follow the instructions on the wizard. Since you will be installing MySQL for the first time, choose Standard Configuration. Using as Windows Service is easy. Select from the drop down box, the service name. It depends on the SQL syntax you are going to use in the application. For the latest, choose MySQL5, otherwise, choose MySQL. This step in configuration is very important. You are here asked to set password as root user. Remember this password because only with this password, you will be able to log on later. Also, if you reinstall after a recent installation of MySQL Server, you will still require to log on with old password. This is last step in the configuration of MySQL Server. Click on Execute to finish the installation. Now open up the MySQL Command Line Client from the Start Menu. Enter your password. Start with creating database. • Type create database student; at the command prompt mysql> • Press Enter and see the above message that your database is now created. • In order to create table, you need to select the database. Do as below. • Then, type create table command as below and press Enter. • Fill your table test with values as below. • To see the inserted values, type select * from test; at command prompt. • Next, type \q to quit the mysql command interface. • Open up notepad. • Type the code as appear in the window. • Save the file as sqltest.php in the C:\Apache\htdocs folder. • Make sure you select all files as type in notepad when saving the file otherwise, it remains a text file not a PHP document. Start your Apache server in Console from the Start menu. See the PHP file being executing on local host connected to Apache Server.
Pages to are hidden for
"MySQL installation with PHP5 and Apache Server 2.2"Please download to view full document