To install MySQL under Windows

Mysql|window This article only discusses how to install MySQL under Windows NT 4.0 or Windows 20000.
I use MySQL for mysql-shareware-3.22.32-win.zip.
First, software download
You can download the Windows version of the MySQL database server software from the following sites:
Http://www.mysql.com/download_win.html
http://chat.hn.cninfo.net/soft/
Second, the Software installation
You can get a detailed installation from Http://www.mysql.com/Manual/manual.html#Win32
Method. You can install it in the following ways:
1, will download the software with WinZip and so on. zip Decompression tool extract to a temporary directory, such as C:\TEMP,
Here with the $install_temp logo;
2, double-click the $install_temp directory to install the SETUP.EXE, installation, the system to you to determine
Install the destination, defaults to C:\mysql, here with the $mysql logo;
3, copy the my-example.cnf file in the $mysql directory as C:\MY.CNF, open with a text editor
C:\MY.CNF, change the #basedir = d:/mysql/in the file to Basedir = $MYSQL, $MYSQL
Replace with your installation destination directory;
4, run cmd or command, open command window;
5, in the command window into the $mysql\bin directory, such as: CD C:\mysql\bin;
6, run Mysqld-shareware--install, so that in Windows services in a more than one named
MySQL services, you can use Windows Service Management program to start or stop the service;
7, now please use Windows Service Management program to start the MySQL database service;
8, after the MySQL installation, the root account password is empty, at this time you can use the following method to change the root
Account password: mysqladmin-u root-p password < New password, it will require you to enter the root account
The old password of the number;
9, then you can use the following methods to test whether the installation has been successful: Mysql-u root-p,
It will require you to enter the password for the root account, and if MySQL has been installed successfully, you will see the following passage:
C:\mysql\bin>mysql-u root-p
Enter Password: * * *
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 3 to server Version:3.22.32-shareware-debug

Type ' help ' for help.

Mysql>
You can then test at the mysql> prompt in such a way that:
Mysql> Show databases
-> Go
+----------+
| Database |
+----------+
| MySQL |
| Test |
+----------+
2 rows in Set (0.05 sec)

mysql> Use test
Database changed
Mysql> CREATE TABLE Test (name char (50))
-> Go
Query OK, 0 rows affected (0.12 sec)

mysql> INSERT into Test (name) values (' Friends, hello, welcome to use MySQL ')
-> Go
Query OK, 1 row affected (0.07 sec)

Mysql> SELECT * FROM Test
-> Go
+---------------------------+
| name |
+---------------------------+
| Friends, hello, welcome to use MySQL |
+---------------------------+
1 row in Set (0.02 sec)

Mysql> exit
Bye

C:\mysql\bin>

Report:
MySQL Download URL
Http://www.mysql.com/download_win.html
http://chat.hn.cninfo.net/soft/
MySQL Installation Guide
Http://www.mysql.com/Manual/manual.html#Win32
MySQL Handbook
Http://www.mysql.com/Manual/manual_toc.html
Http://www.mysql.com/Manual/manual.html