"Set CharSet" Win7 64-bit system installation MySQL5.5.21 illustrated tutorial

We all know that MySQL is a small and medium-sized relational database management system, very practical, for us to learn a lot of technology is helpful, a few days ago I installed SQL Server 2008 and Oracle 10g database, also used JDBC to connect them, there is no garbled. Yesterday to see the classmate with Java connection MySQL database, there is garbled, this is I do not know, I immediately go online to check JDBC Connection MySQL operation, found in the JDBC connection to the MySQL database to pass a can solve garbled parameters, To insert data that is not garbled into the database. This is one of the reasons I want to install MySQL database, and I want to experience the following it, plus the class of machine configuration is relatively low, installed MySQL database to do the experiment is the best choice, it is because of these two reasons I installed MySQL, in the process of installation some problems let me pay attention to In the process I took the steps to cut the diagram, I hope to be helpful to those in need, my database is 5.5.21 this version. Here are my installation steps:

1, first click the installation file of MySQL5.5.21, the Installation wizard interface of the database appears, click "Next" to continue the installation:

2. In the open window, select accept the installation agreement, click "Next" to continue the installation:

3, in the selection of installation Type window, there are "typical (default)", "Complete", "Custom (User Defined)" Three options, we choose "Custom", because through customization can let us more familiar with its installation process, click " Next "Continue with the installation:

4, in the Custom installation interface, select the installation path of MySQL database, here I set the "D:\Program file\mysql", click "Next" to continue the installation:

5, next into the ready to install the interface, first confirm the previous settings, if wrong, press "back" to return, no errors, click the "Install" button to continue to install:

6, click the "Install" button appears following the installation of the interface, after very little time, the MySQL database installation completed, the completion of the MySQL installation interface,:

This interface clicks "Next" on the line.

Note To select the "Launch the MySQL Instance config Wizard" option above, this is the configuration to start MySQL, click the "Finish" button and go to the configuration screen.

7, the installation of MySQL database is very simple, the key is the configuration after the completion of the installation, click to complete the following Configuration Interface Wizard, click "Next" To configure:

8, in the Open Configuration Type window to select the way of configuration, "Detailed configuration (manual precise configuration)", "Standard Configuration", in order to familiarize ourselves with the process, we choose "detailed Configuration (manual and precise) ", click" Next "to continue:

9. In the window that appears, select the type of server, "Developer Machine (Development test Class)", "Server machine (server type)", "Dedicated MySQL server machine (dedicated database server)", We are only used for learning and testing, the default is OK, click "Next" to continue,:

10, in the configuration interface that appears to choose the purpose of MySQL database, "Multifunctional database (General purpose)", "Transactional database only (server type)", " Non-transactional Database only (non-transactional) ", here I select the first item, generic installation, click" Next "to continue the configuration:

11, in the appearance of the interface, to InnoDB tablespace configuration, is to select a storage space for InnoDB database files, if modified, to remember the location, reload the time to choose the same place, otherwise it may cause database corruption, of course, A backup of the database is no problem:

12. In the open page, select the number of MySQL visits, simultaneous connections, "decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500 or so)", "Manual Setting (manually set, set to 15) Select manual Settings Here, click" Next "to continue:

13, in the open page set whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on their own machine, which is connected to Java operation, the default port is 3306, and enable strict syntax settings, click "Next" to continue:

14, in the Open character encoding page, set MySQL to use the character encoding, the first one is the Latin code, the second is a multi-byte universal UTF8 encoding, the third is manual, we choose Utf-8 or GBK, click "Next", continue to configure:

15. In the open page, choose whether to install MySQL as a Windows service, you can also specify the service name (the Services identity name), whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin, Instead of pointing out the directory name, such as a connection, "Mysql–u username–p password;" Yes, click "Next" to continue with the configuration:

16, in the open page set whether to modify the default root user (super Administrator) password (default is empty), "New root password", if you want to modify, fill in the new password here, and enable the function of root remote access, do not create anonymous users, click "Next" Continue the configuration:

17, to here all the configuration operations have been completed, click the Execute button to perform the configuration:

18, after a few minutes, appears the following prompt interface on behalf of the MySQL configuration has ended, and prompted the success of the information.

19. Start the MySQL database in the service and enter "Mysql–h localhost–u root-p" in the command window, then enter the user's password in the prompt that appears:

You can see that the MySQL database was successfully logged in after it was started, where we can operate the database.

Reference article: http://blog.csdn.net/ni_hao_ya/article/details/9235251

"Set CharSet" Win7 64-bit system installation MySQL5.5.21 illustrated tutorial