How to Install MySQL on Windows XP- Step-to-Step Guide

For a long time I desired to write an article about MySQL installation on Windows XP and finally the time arrived to complete it, I several time suffered the same hiccups during the installation of MySQL. Every time I have to search for the solutions. 

Step-to-step Guide to install MySQL on Windows XP

• You have to download the latest stable version of MySQL from the community site and save it in /tmp/src.

# cd /tmp/src/# gunzip -dc mysql-x.xx.xx.tar.gz | tar xv# cd mysql-x.xx.xx# ./configure --prefix=/usr/local/mysql# make# make install

• MySQL is installed. Now you need to create the grant tables:

# scripts/mysql_install_db 

 Then start the MySQL server: 

# /usr/local/bin/safe_mysqld &

• And test your installation by typing:

mysql -uroot –p

At the password prompt, just press Enter. You should see something like:

Welcome to MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version 3.22.34
Type 'help' for help.
mysql> 

If you notice this, you have MySQL running properly. If you don't, then try to instal MySQL

once again. Type status to see the MySQL server status. Type quit to exit the prompt.