WebDevelopersNotes logo

home-icon Home / MySQL / Installing MySQL on Windows

Installing MySQL on Windows

Installing MySQL on Windows

Once you have successfully downloaded the Windows version, installing it on the operating system a breeze… trust me! It may seem intimidating if you are a beginner, but by following the directions down to a T you will have the database application up and running.

The installation steps detailed on this page have be tested on Win95 and Win98 using mysql-shareware-3_22_34-win.zip. Yes, these are old!

Update for Windows 7 users: For step-by-step instructions, please check the page on how to install MySQL on Windows 7.

Sponsored Links

  1. Create a temporary directory called mysqltem.
  2. Unzip the file to this directory.
  3. After unzipping is over, you’ll find a file called “setup.exe”.
  4. Close all programs
  5. Click on Start – Run and browse to the setup file in mysqltem.
  6. Click “OK” to proceed
  7. The setup program loads and guides you through the installation process.
  8. Choose the “Typical” installation, unless you know what you want!
  9. MySQL would be installed in c:\mysql (unless you specified some other directory).
  10. Restart Windows.
  11. Start an MS-DOS session and migrate to c:\mysql\bin
  12. Now, type the following at the prompt:
    mysqld-shareware --standalone
    
    OR (in later versions)
    mysqld
    

    This starts the MySQL server.

  13. Type “mysql” (without the quotes) at the DOS prompt.
  14. The prompt is changed to the “mysql” prompt.
  15. To test the MySQL server, type “show databases;” at the prompt.
  16. This should display something like:
    +----------------+
    | Database       |
    +----------------+
    | mysql          |
    | test           |
    +----------------+
    2 rows in set (0.00 sec)
    

    If you see the above… congrats… you have sucessfully installed MySQL on your system.

  17. Type “quit” at the mysql prompt.
  18. You are now back to the MS-DOS prompt.
  19. Since our work is done (for the time being), we should shut the MySQL server. Issue the following command at the prompt.
    mysqladmin -u root shutdown
    

Sponsored Links

Your comments
Star icon IMPORTANT Have a question / problem? Click here to ask an expert.

JOKE - Being a Programmer

Sponsored Links

Tips

How do I view a deleted web page?
Is there a way to view a deleted web page - one that is no longer available? Yes there is and the solution is quite simple. [more...]

Fact

The first user of the internet was Charley Kline, a student of the University of California, Los Angeles. He sent the first message which consisted of just five characters - "login". It was transmitted over the ARPANET, the network of the Advanced Research Projects Agency and the precursor of the Internet. The message was sent on 29th October 1969 from UCLA's SDS Sigma 7 Host computer to the Stanford Research Institute's SDS 940 Host computer.Technically, at that time, ARPANET wasn't the Internet, as we know it, because it wasn't running the TCP/IP protocol! [more...]

We use cookies to give you the best possible website experience. By using WebDevelopersNotes.com, you agree to our Privacy Policy