Install MySQL in Windows

Source: Internet
Author: User
Tags mysql download mysql manual
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.