build-website-header
spacer-image
 

Installing Wordpress On Windows (2000 and XP)-Part 3 MYSQL Install

 

Now you need to download MYSQL.

 The version I used was version 4.0.26. You need to download the Windows install files (ZIP file) and upzip them on your machine.

You don't need the source files so don't download that version.

You then run the setup.exe program and do the install. You will be asked for a file location (default c:\mysql).

If you choose another location you may  get a message about editing the my.ini file, you can ignore it.

The directory structure created by the install is shown below:

 

mysql folder structure

The bin directory contains the admin programs that you use to administer MYSQL. A quick check to see if everything is installed of is to go to the bin directory and run winmysqladmin.exe.

winmysqladmin

When you run it it will ask for a user name and password. This I found confusing as it isn't the user name and password for MYSQL but just for the admin tool!!

If you now open the my.ini file which you can view form inside the winmysqladmin tool (click thumbnail image below) you will see what I mean

winmysql admin thumbnail

Click to open larger version in new window

winmysqladmin tool appears as traffic light is the system tray. If you right click it and select show me it opens up and you can view the various settings. You can stop the Mysql database from running and restart by clicking the traffic lights selecting WIN NT and Stop the service.

You will find the my.ini file in the windows directory (or winnt). I'm not sure whether the install put it there, or the winmysqladmin tool did. Here are the contents.

You should ensure that the port=3306 in uncommented (i.e. remove the leading # blue highlight).

[mysqld]
basedir=F:/mysql
#bind-address=192.168.1.66
datadir=F:/mysql/data
#language=F:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=F:/mysql/bin/mysqld-nt.exe
user=administrator
password=password
 

Note: you can edit the my.ini file using Notepad or via the winmysqladmin tool.

Now the Database is installed and running its time to create the database and database user for Wordpress.

Google
Web www.build-your-website.co.uk


 

spacer2-image