How to install mySQL 4.0.x on Windows
This article explains how to install, configure and run mySQL 4.0.x under Microsoft Windows. Note! You might want to install Apache HTTP server first.
Published 07.12.2005 - Last edited 08.12.2005 - 8995 views - 0 comments
1. Download and Unpack
Download and install mySQL from
http://dev.mysql.com/downloads/mysql/4.0.html. Just make sure you get a
Windows 95/98/NT/2000/XP/2003 (x86) binary version.
My file was named: mysql-4.0.18-win.zip
2. Install mySQL 4.0.x
Unzip mySQL to a temporary directory of your choice. (I used c:\mysql-setup\ for this) Open that directory then run
setup.exe and install mySQL to somewhere like
c:\mysql\
3. Finding the Administration
Unfortunately the latest version of mySQL I tried did not include any type Start
Menu shortcuts. So manually go into your mySQL directory and look for winmysqladmin in my case it was at c:\mysql\bin\winmysqladmin.exe. Run it. After you enter
your username/password it will minimize to the System Tray (by your windows
clock) and there won´t be a taskbar button.
4. Starting mySQL
There are several ways to start mySQL, but the easiest is to simply right click
above the tabs on the Admin window, and select Win 9x or Win NT (XP) and start
database or install/start service. Note! When you want to shut down the
database, ShutDown this tool or hitting the
windows "X" simply shuts down the Administration window, it does not stop mySQL.
So be sure you get the "Stop this Service" first.
5. Testing mySQL
Testing mySQL is not exactly easy. However, here are the common connection
strings for PHP and CGI. I´ve also started recommending people download phpMyAdmin and use it to create databases,
etc.
Security Note:
Even though you entered a username/password, mysql runs using the username
"root" and no password by default. Although mysql doesn´t allow
connections from remote hosts unless you specifically allow it, you should
probably set a password for "root" and/or add new users.
6. Setting a root password for mySQL
- Start your command line by going to the Start Menu > Run and typing cmd (or
type command if you are using an older version of windows), change your
directory to wherever you installed mysql to:
C:\> cd C:\mysql\bin
- Switch to mysql command line:
C:\mysql\bin> mysql -u root mysql
- Then set a default password:
mysql> SET PASSWORD FOR root@localhost=PASSWORD(´mysecret´);
where "mysecret" is the password you want to use.
7. Adding more users to mySQL
- Start your command line by going to the Start Menu > Run and typing cmd (or
type command if you are using an older version of windows), change your
directory to wherever you installed mysql to:
C:\> cd C:\mysql\bin
- Switch to mysql command line:
C:\mysql\bin> mysql -u root mysql
- Shen then add your new user:
mysql> GRANT ALL PRIVILEGES ON *.* TO billgates@localhost IDENTIFIED BY ´microsucks´;
where "billgates" is the username and "microsucks" is the password you want to use.
Configuring cron jobs on Windows
Up one level
PHP Sniplets