Setting up your first web server on windows with Apache, PHP and MySQL
by Amit Arora
Published: August 5, 2003
User Rating: 9.1 (510 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

    basedir=d:/mysql

    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

About

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
Uptime