Shulou(Shulou.com)06/01 Report--

[development environment]

Physical version: Win 7 Ultimate Edition (64-bit)

MySQL version: 5.5.40MSI version (64-bit)

1. Database type:

(1) Relational database

(2) object-oriented database

(3) XML database

Now the mainstream is relational database.

II. Database products:

Large databases include: Oracle, Sybase, DB2, SQL server

Small databases include: MySQL, Access, etc.

The databases listed above are all relational databases, but a small part of Oracle is object-oriented. MySQL has the characteristics of open source and free, so it is suitable for the development of small and medium-sized enterprises.

Third, the basic concepts of relational database:

A relational database is a collection of data composed of multiple tables (table) and the relationship between tables. A table is a two-dimensional relational structure composed of several rows and columns.

In the figure above, the columns of the table are called fields (field), and the rows of the table are called records (record). Fields are the structure of the table, and records are the data of the table.

4. Download MySQL:

Download address on official website: http://www.mysql.com/:

In the figure above, you can see that there are three versions of MySQL: enterprise Edition, Cluster Edition, and Community Edition. The community version is the version we need, and GPL is an open source protocol. Click the link in the red box in the image above to enter another interface:

In the image above, we select the community version of the red box to download, and the following interface pops up:

In the following figure, you can see that MySQL supports many platforms:

My operating system is 64-bit. I choose the corresponding version (MSI version) to download. Click the link in the red box in the image above to enter the following interface:

In the image above, click the red box to download, and the following interface pops up:

In the picture above, we don't need to register, click on the red box and download it directly.

5. Installation of MySQL:

This error occurs when you double-click the installation package:

Well, I didn't expect that all the software downloaded from the official website could go wrong. Forget it. I'll play the old version.

Click the red box in the image above, and the following interface pops up:

In the image above, click on the red box and the following interface pops up:

No need to register, just download it.

5. Installation of MySQL:

After the software download is complete, start the installation.

In the figure above, it is recommended to select the Custom of the second item to customize the installation. The following interface pops up:

In the image above, select the appropriate installation path and click "continue":

Then another dialog box pops up, and let's install a visual tool:

In the image above, we check the red box, and then click "finish" to configure.

6. Configuration of MySQL:

Explanation of the figure above: in the future, in Java development, to access this server, it will involve the communication protocol. TCP/IP protocol is used here, and the port is involved at this time. The default port number of MySQL is 3306. Use the default one. Move on to the next step:

In the figure above, you select the encoding of the database. The first is Latin, which only supports English, not Chinese; the second seems to be related to Japanese. Here we choose the third one: customization. Then set the encoding method to: utf-8. Next step:

In the figure above, we check "add path to environment variable" and then continue:

In the figure above, the password is set for the root user. Here, I set the password to smyh. In addition, check "allow users to access remotely (network)", otherwise you can only access it locally. Continue:

The above tick will hit automatically:

In the figure above, you can see that our configuration is written in the my.ini file.

Click finish to complete the installation. Let's take a look at the contents of the my.ini file in the corresponding directory:

View Code

At the same time, we can also see the installed programs in the programs on the start menu:

Click it to start running:

Open computer Management to see that the service for MySQL has been started:

At the same time, you can also see in the process:

5. Uninstall MySQL:

1. Delete the mysql software in the control panel first

2. Delete the installation directory of mysql (if there is a setting directory on other disks, delete the empty directory, too)

3. Delete the following files in the registry: (press the "Win+R" key, enter regedit to enter the registry):

HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL

HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL

Delete all if any (tip: use F3 loop to find "mysql")

4. If it is a windows 7 system, you also need to find C:\ ProgramData\ MYSQL to delete it; if it is a XP system, delete it and find C:\ Documents and Settings\ All Users\ Application Data\ MYSQL

It can be installed again after completion, and there is no need to restart the system.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.