MySQL5.6.15
Official:
Http://dev.mysql.com/downloads/windows/installer/
The above clearly indicates that the MySQL installation program is 32-bit, but 32-bit and 64-bit binary files are installed at the same time. Therefore, it is also applicable to 32-bit and 64-bit Windows operating systems.
There are two download points. The above 1.5M is an online installation program. We will download the following 234.8M file, which can be directly installed after download. Click Download, as shown below:
Prompt that you need to log on or register. If you do not need to, you can skip this step and click "No thanks" in the lower left corner to download just start my download.
After the download is complete, you can modify the installation path during the installation process. Most of the other options can be set by default. The password set during the installation process is very important.
After installation, open the service: Control Panel> Management Tools> service, find the MySQL56 option in it, right-click the property, and select Automatic In the Startup type, click Start, and then click OK.
Then, in the Start Menu, MySQL can be found in the program and MySQL.
In MySQL Server 5.6, click MySQL 5.6 Command Line Client to start Command Line mode and enter the password:
If the connection succeeds, go to mysql> and enter the command select version (), user (), current_date; to view the version number, user, and current time.
Enter the show databases command to view all databases currently.
Then you can perform related database operations
MySQL also provides the workbench mode and graphical interface, which is more convenient,
That is, MySQL Workbench 6.0 CE.
On the menu bar, choose Database> Connect to database. Press default and click OK.
Enter the password here
Click the "create database" icon: circled in red, enter the database name, click "Apply", jump out of code, and click "Apply ".
Then you have created a database. In the lower-left corner, you can see the created my_dababase database, click Tables, right-click Create Table, and Create a new Table ..... You can use the database.
The checkbox indicates:
Check the database on the server and you can see that the my_database database you just created appears:
For more information and tutorials on MySQL, see:
MySQL5.1 official Chinese manual
Http://dev.mysql.com/doc/refman/5.1/zh/index.html