Install MYSQL in Windows XP

1. download the installation file and find the ZIP file on the official MySQL website. the following prompt is displayed: some are installation files, which will be prompted during installation. here we will not explain it. 2. decompress the file, it is better to place the selected location in the mysql folder of a disk, which is easier to find. here we extract the file to the SyntaxHighlighter of drive D. all (); 1. download the installation file

To mysql.com/"target = _ blank>Official MySQL websiteFind the ZIP file

Tip: Some are installation files, which will be prompted during installation. we will not explain them here.

2. decompress the file and select the location

It is better to put it in the mysql folder on a disk, which is easier to find. here we extract the file to the mysql folder on disk D.

3. let windows know where your MySQL is located

Create a my. ini file in the Windows home directory of the system disk. the content is as follows:

[Mysqld]
Basedir = D:/mysql/
Datadir = D:/mysql/data/

Then, set the PATH environment variable. Add D: mysqlin, so that mysql can be directly used when you enter the command mode next time, instead of moving to the mysql/bin directory of disk D.

4. add Windows services to MySQL

This means that MySQL can be automatically started when windows is started.

In command line (CMD) mode, first go to the mysql/bin directory of disk D, then enter

Mysqld-nt-install

If it succeeds, a prompt will be displayed:

Server successfully installed.

5. restart the computer. installation is complete.

After restarting, go to "control panel"-"service" to check whether MySQL is available and whether it is "started ".

If you do not want MySQL to be started directly every time you start the computer, you can change the automatic item to manual.