Win7 system Installation MySQL5.5.21 Illustrated tutorial _mssql2005

We all know that MySQL is a medium and small relational database management system, very practical, for us to learn a lot of technology are helpful, I installed a few days ago, SQL Server 2008 and Oracle 10g database, but also with JDBC to connect them, there is no garbled.

Yesterday to see students using Java to connect the MySQL database, there are garbled, this is I do not know, I immediately go online to check JDBC connection to the operation of MySQL, found in the JDBC connection to the MySQL database to pass a can solve garbled parameters, In order to insert data that is not garbled into the database. This is because when the database is installed, the correct encoding is not chosen. So this is one of the reasons I want to install the MySQL database, want to experience the following it, plus the class 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 installing some problems let me very much attention, I truncated the steps during the installation process, hoping to help people in need, my database is 5.5.21 this version.

The following are the contents added after December 21, 2012:

Read this blog is very good, so with the MySQL download process, I hope to help people in need:

1, the first in Baidu search MySQL, such as the figure to select the first search term, as shown in the picture:

2, in the open page, select the following figure "Download" connection, as shown in the figure:

3. For MySQL download is divided into several versions, we only need to download the server is enough. About 30M More, select the connection below, as shown in the figure:

4, the final offer 5.5.28 Download Connection Address of this server:

Http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.28-win32.msi

Next is the installation steps for my MySQL database server:

1, first click MySQL5.5.21 installation file, the Database Installation Wizard interface, click "Next" continue to install, as shown in the figure:

2, in the open window, choose to accept the installation protocol, click "Next" to continue the installation, as shown in the figure:

3. In the window where the Select installation type appears, there are "typical (default)", "Complete (Full)", "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, as shown in the figure:

4, in the appearance of the custom installation interface to choose the MySQL database installation path, here I set the "D:\Program file\mysql", click "Next" continue to install, as shown:

5, the next step into the installation of the interface, first confirm the previous settings, if wrong, press "back" returned, no errors, click the "Install" button to continue the installation, as shown in the picture:

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

Click "Next" on this interface.

Note To select the "Launch the MySQL Instance Configuration Wizard" option above, which is the configuration to start MySQL, is also the most critical place, click the "Finish" button to enter the configuration interface.

7, MySQL database installation 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, as shown:

8, in the Open Configuration Type window to select the way to configure, "Detailed Configuration (Manual precise configuration)", "Standard Configuration (Standard configuration)", in order to familiarize ourselves with the process, we choose "Detailed Configuration (Manual exact configuration), click Next to continue, as shown in the figure:

9. In the window that appears, select the type of server, Developer Machine (Development test Class), Server Machine (server type), dedicated MySQL server Machine (Specialized database server), We just use it to learn and test, by default, click "Next" to continue, as shown in the picture:

10, in the appearance of the configuration interface to choose the use of MySQL database, "The Multifunctional Database (Universal multi-function)", "Transactional database only (server type)", " Non-transactional Database only (non-transactional) ", here I select the first item, general installation, click" Next "continue to configure, as shown in the figure:

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

12, in the Open page, choose the amount of MySQL access, at the same time the number of connections, "Decision Support (DSS)/olap (20)", "Online Transaction Processing (OLTP) (500 or so)", "Manual Setting (set manually, set to 15) Here, select manual Settings and click" Next "to continue, as shown in the figure:

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

14, in the Open character code page, set MySQL to use the character encoding, the first is the western code, the second is multibyte universal UTF8 encoding, the third is manual, we choose Utf-8, if here is not selected UTF-8 this encoding, When using JDBC Connection database, will appear garbled, then need to add the following code "Useunicode=true&characterencoding=utf-8", can solve the garbled problem, for later convenience so set for UTF-8 code , but there is a problem, that is when using which console to insert Chinese characters, will be an error, query the table with Chinese characters, can not display Chinese characters, where you need to enter MySQL each time, set a system parameter "set names GBK", you can solve the problem, next click "Next", continue to configure, As shown in the figure:

15, in the open page to choose whether to install MySQL as a Windows service, you can also specify service name (services identity name), whether the MySQL bin directory to add to Windows PATH (after joining, you can directly use the file under Bin), Instead of pointing to directory names, such as connections, "mysql–u username–p password;" On it, click "Next" to continue with the configuration as shown in the figure:

16. In the open page, set whether you want to modify the default root (super Administrator) password (default is null), "New root password", if you want to modify, fill in the new password, and enable the root remote access function, do not create anonymous users, click "Next" Continue with the configuration as shown in the figure:

17. All of the configuration operations here have been completed, and click the Execute button to perform the configuration as shown in the figure:

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

19, in the service will be the MySQL database startup, and in the command window to enter "Mysql–h localhost–u root-p" or "mysql-h localhost-uroot-p password", and then in the prompts to enter the user's password, as shown in the figure:

You can see from the diagram that the MySQL database after the start of the successful login, where we can operate the database.