Setting up your first web server on windows with Apache, PHP and MySQL
by Amit Arora
Published: August 5, 2003
User Rating: 9.1 (514 votes)

Page Page » 1 2 3 4 5 6 7 8

Installing MySQL

  1. Install the MySQL by executing the installation file, in case of installer. Or unzipping the zip package to a directory, in case of zip package. It is advised to install the MySQL in the root directory like c:\mysql or d:\mysql

    In case you are installing MySQL in directory other than c:\mysql, create a file my.ini in the WINDOWS directory and add the followin line to it


    Enter the absolute path of the directory where you installed the MySQL. (take care while entering the slashes)

  2. To start the mysql server, execute the c:\mysql\bin\mysqld.exe file on Windows 95/98 or c:\mysql\bin\mysqld-nt.exe on Windows NT/2000/XP. Now run c:\mysql\bin\mysql.exe (the mysql client). If you are successfull in connecting to the server, mysql has been successfully installed.

  3. I would also recommend you to create shortcut to the following for easily starting and stopping MySQL:
    MySQL Start: c:\mysql\bin\mysqld-nt.exe --standalone
    MySQL Stop: c:\mysql\bin\mysqladmin.exe -u root -p [root_password] shutdown
    where [root_password] is your root password. If it is empty, then use this instead
    c:\mysql\bin\mysqladmin.exe -u root shutdown

Page Page » 1 2 3 4 5 6 7 8


Amit Arora is web developer with expertise in developing eCommerce enabled websites for the businesses.

Contact | Resume

Subscribe to newsletter

Get Firefox

Monitored by Site24x7