MySQL Learning 3:windows 64-bit OS verify MySQL

Verify that there is a MySQL service in the list of computer services

(1) Right click on the desktop computer icon appears menu list options, check management (there are several ways to open the computer local services list, here is just

The way I used to open it).

(2) When the Computer dialog box appears, click the Open Service and Application service option.

(3) on the right side of the list of services to find out if there is a service named MySQL, and check whether to start, this means that we installed the MySQL service has

Success. If the MySQL service is started automatically, it means that our configuration is successful.

Two Verify that the computer PATH environment variable is configured with the MySQL installation directory

(1) Right click on the computer icon on the Desktop menu list option appears, select Properties.

(2) Select Advanced system settings on the left.

(3) Select the environment variable in the System Properties dialog box that appears.

(4) In the Environment Variables dialog box that appears, locate the PATH environment variable in the list of system variables and click Edit.

(5) In the variable value of the Edit system variable path we found the C:\Program files\mysql\mysql Server 5.5\bin;

The configuration of the MySQL service has been successful.

This is quite similar to our configuration of the Java development environment.

three MySQL installation directory structure

In the C drive we can find the MySQL Server 5.5 folder under the folder named MySQL, the following is the file directory in the folder:

File directory Interpretation:

(1) Bin directory: stores executable files.

(2) The Data directory: stores the file.

(3) Include directory: stores the included header files.

(4) Lib directory: Repository file.

(5) Share directory: Error message and character set file.

(6) The rest of the MySQL configuration file suffix. ini, the most important is the My.ini configuration file.

Four Setting the default encoding for MySQL

If we successfully installed MySQL, then it is encoded by default in Latin1 (Latin), which is not in accordance with the encoding method we have learned, because

No, we are used to encoding GBK 2312 or UTF-8, so need to Modify the encoding, in the subsequent creation of the database file we will encounter

the same question questions.

To modify the encoding method step:

(1) in the MySQL directory (my C:\Program files\mysql\mysql Server 5.5), locate the My.ini profile and double-click it to open it.

(2) search under the client:

[MySQL]

default-character-set=latin1

Switch

[MySQL]

Default-character-set=utf8

(3) Looking for the client again:
[Mysqld]
Character-set-server=latin1
Switch
[Mysqld]

Character-set-server=utf8

(4) Since the MySQL configuration file has been modified, the MySQL service needs to be restarted and the configuration file changes to take effect. You can also right-click

MySQL service Reboot . There are several ways to restart the MySQL service, as well as a restart of the command-line mode.

We do not verify the default encoding for MySQL services here, which is described later in this article.

MySQL Learning 3:windows 64-bit OS verify MySQL