Mysql Learning the third day verify Mysql_mysql under Windows 64-bit operating system

Verify that the MySQL service is available in the list of computer services

(1) Right-click on the Desktop computer icon appears menu list options, selected management (there are several ways to open the computer Local Service list, here is just the way I used to open).

(2) The Computer dialog box appears, click Open Service and the service option in the application.

(3) on the right-hand side of the list of services to find whether there is a name for MySQL services, and to see whether the launch, which means that our installation of MySQL service has been successful.

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

Second, verify that the computer PATH environment variable is configured with the MySQL installation directory

(1) Right-click on the Desktop computer icon appears menu list options, 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 presence of the Environment Variable dialog box, locate the PATH environment variable in the list of system variables and click Edit.

(5) In editing the variable value of the system variable path we found the C:\Program files\mysql\mysql Server 5.5\bin; This indicates that our configuration of the MySQL service has been successful.

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

Third, MySQL installation directory structure

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

File directory Explanation:

(1) Bin directory: stores executable files.

(2) Data directory: the storage of files.

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

(4) Lib directory: Repository file.

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

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

Four, set MySQL default encoding method

If we succeed in installing MySQL, the default encoding is Latin1 (Latin), which does not correspond to the encoding we are learning, because we are used to coding in GBK 2312 or UTF-8, so we need to modify the encoding method, We have the same problem when we create the database file later.

To modify the encoding method step:

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

(2) Looking for under the client:

[MySQL]

Default-character-set=latin1

To

[MySQL]

Default-character-set=utf8

(3) Again looking for the client under:
[Mysqld]
Character-set-server=latin1
replaced by:
[Mysqld]

Character-set-server=utf8

(4) Since the MySQL configuration file has been modified, the MySQL service needs to be restarted for the modification of the configuration file to take effect. You can also right-click the MySQL service reboot. There are several ways to restart the MySQL service, as well as a command-line reboot.

Here we do not verify the MySQL service default encoding, the following article will be introduced, I hope that we continue to focus on small series for everyone to organize a series of articles, do not miss Oh!