This article only discusses how to install MySQL in WindowsNT4.0 or Windows20000. Mysqlis mysql-javasware-3.22.32-win.zip. 1. download the software. you can download the MySQL database server software for Windows from www.mysql.comdownload_win.html chat. hn. cninfo. netsoft 2. install mysql
This article only discusses how to install MySQL in Windows NT 4.0 or Windows 20000.
Mysqlis mysql-javasware-3.22.32-win.zip.
I. software download
You can download the MySQL database server software for Windows from the following sites:
Http://www.mysql.com/download_win.html
Http://chat.hn.cninfo.net/soft/
II. software installation
You can get detailed installation from http://www.mysql.com/manual/manual.html?win32
Method. You can install it using the following method:
1. decompress the downloaded software using winzip.zip to a temporary directory, such as C: \ TEMP,
$ INSTALL_TEMP is used here;
2. double-click SETUP. EXE in the $ INSTALL_TEMP directory for installation. during installation, the system requires you to confirm
The installation destination. the default value is c: \ mysql. $ MYSQL is used here;
3. copy the my-example.cnf file under the $ MYSQL directory to c: \ my. cnf and open it in a text editor.
C: \ my. cnf, replace # basedir = d:/mysql/in this file with basedir = $ MYSQL, $ MYSQL
Use your installation destination directory instead;
4. run cmd or command to open the command window;
5. enter the $ MYSQL \ bin directory in the command window, for example, cd c: \ mysql \ bin;
6. run mysqld-policware -- install. in this way, an additional name is added to the Windows service.
MySQL service, you can use Windows service management program to start or stop the service;
7. use the Windows service management program to start the MySQL database service;
8. After MySQL is installed, the password of the root account is blank. in this case, you can use the following method to change the root account:
Account password: mysqladmin-u root-p password <新密码> It requires you to enter the root account
The old password;
9. you can use the following method to test whether the installation is successful: mysql-u root-p,
It requires you to enter the password of the root account. if MySQL has been successfully installed, you will see the following section:
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-ware-debug
Type 'HELP' for help.
Mysql>
In this case, you can run the following command at the mysql> prompt:
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 ('dear friend, welcome to mysql ')
-> Go
Query OK, 1 row affected (0.07 sec)
Mysql> select * from test
-> Go
+ --------------------------- +
| Name |
+ --------------------------- +
| Dear friend, welcome to MySQL |
+ --------------------------- +
1 row in set (0.02 sec)
Mysql> exit
Bye
C: \ mysql \ bin>
Appendix:
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 manual
Http://www.mysql.com/Manual/manual_toc.html
Http://www.mysql.com/Manual/manual.html