Monday, 15 June 2009

Install MySQL and configure it with your pc


MySQL is the most popular database server because it's a open source software. And this sofware is widely used with php. In this turorial I'll show you how to install MySQL database Server on your computer using localhost. So lets start...

1. To install MySQL on Windows platform, get the latest version of MySQL from the http://mysql.com. After downloading the binary file (e.g .exe) for windows double click the executive file the installation wizard appear.

2. Click next until it finished installation process. After finishing installation a window will appear and want to give the user name and password. This window will come anywhere in the installation process. Give your name and a password. This name and password will be needed when you enter into the MySQL server. Note that in the installation process the higher version of MySQL (here i'm using MySQL 1.4 version) may needs your host name. If it does type your host name as localhost or if you have any host then select your host .Click ok or Finish to complete the installation process.

3. After successfully install MySQL on your pc find the directory where to install this program. This directory would be C:\mysql or C:\Program Files\mysql or enywhere else. Go on to the mysql directory ../mysql/bin and find the "winmysqladmin.exe" file. Just below the figure:

4. After double clicking this file WinMySQLadmin window will appear. All of the database information is given here. Here you'll find the "my.ini" tab. Select this tab, you'll get your user name and password that is needed to assess the database. After clicking this file MySQL database will be created into the ../mysql/data directory. So clicking this file is necessary. The WinMySQL window is given below:



5. In C:\windows directory a "my.ini" file is also created. Open this file using Notepad and check this information. If all information is right close this and you're ready to enter into the MySQL server.

Now after completing this tasks MySQL database Server is completely installed in your computer. In the next turorial we'll show how to access into the MySQL database Server, create a database, how to show database and so on.

Thanks for reading this tutorial.