Windows 7 system Installation MySQL5.5.21 diagram

Win7 System Installation MySQL5.5.21 diagram

We all know that MySQL is a small and medium-sized relational database management system, very useful, 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, hair now use JDBC Connection MySQL database to pass a can solve garbled the number of parameters, Ability to insert data that is not garbled into the database. This is due to the fact that the correct encoding was not chosen when the database was installed. So this is one of the reasons I want to install MySQL database, want to experience below it, plus the class of machine configuration is relatively low, installed MySQL database to do experiments is the best choice, precisely because of these two reasons I installed the MySQL, in the process of installation some problems let me very attention, In the process of installation I took the steps to cut the diagram, I hope to have the necessary people to help, my database is 5.5.21 this version number.

The following is a description of what was added after December 21, 2012:

Look at this blog is very good, so added the MySQL download process, I hope to be helpful to those who need:

1, first in Baidu search MySQL, select the first search term, see:

2, in the open page, select the "Download" Connection in, see:

3., for MySQL download is divided into multiple version numbers, we just need to download the server is enough. About 30M More, choose the connection that you see:

4. Last offer 5.5.28 Download Connection address for 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 the installation file of MySQL5.5.21, the Installation wizard interface of the database appears, click "Next" to continue the installation, see:

2. In the open form, Select accept the installation agreement, click "Next" to continue the installation, see:

3, in the form of selecting installation type, there are "typical(default)", "Complete", "Custom (User Defined)" Three options, we choose "Custom", Since we can more familiarize ourselves with the installation process through our own definition, it is very helpful to learn MySQL database, click "Next" to continue the installation, see:

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

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

6 , click "Install" button after the appearance of such as the following installation of the interface, after very little time, the MySQL database installed, completed the MySQL installation interface, see:

this interface clicks "Next".

Note To select the "Launch the MySQL Instance configuration Wizard" option above, which is the configuration to start MySQL and the most critical place (and can be set later), click "Finish" button to enter the configuration interface.

7 , MySQL database installation is very simple, the key is the configuration after the installation, after clicking on the Configuration Interface Wizard, such as the following, click "Next" to configure, see:

8 , in the Open Configuration type form, select how to configure, "detailed Configuration (manual and precise), "standard Configuration", in order to familiarize ourselves with the process, we select "Detailed configuration (manual precise configuration)", click "Next" to continue, What you see:

9 , in the form that appears, select the type of server, Developermachine (Development test Class), Server machine (server type), dedicated MySQL server Machine (dedicated database server) ", we are only used to learn and test, by default, click" Next "to continue, see:

Ten , select the purpose of MySQL database in the configuration interface that appears, "Multifunctional Database (Universal multifunction)", "Transactional database Only", " Non-transactional Database only (non-transactional) ", here I select the first item, generic installation, click" Next "to continue the configuration, see:

One , in the interface, the InnoDB tablespace configuration, is to select a storage space for InnoDB database files, assuming that the change, to remember the location, re-install the time to choose the same place, otherwise it may cause database corruption, of course, Make a backup of the database is no problem, what you see:

A , on the page that opens, select the amount of access to MySQL, the number of connections at the same time, "decision Support (DSS)/olap (20 or so)", "Online Transaction processing (OLTP) (500 or so) "," Manual Setting (manually set, set to 15) here Select manual Settings, click "Next" to continue, what you see:

- , in the open page set whether to enable TCP/IP connection, set port, if not enabled, just can access the MySQL database on their own machine, which is connected to Java operation, the default port is 3306, and enable strict syntax settings, Assuming that an error occurs later, you can select the option "Add firewall exception for this port" and click "Next" to continue, as seen:

- , 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, assuming there is no choice UTF-8 this encoding, When using JDBC to connect to the database, there will be garbled, then need to add such as the following code "Useunicode=true&characterencoding=utf-8", talent enough to solve the garbled problem, For later convenience so set to UTF-8 encoding, but there is a problem, that is, when using which console inserted Chinese characters, will error, query with Chinese characters table, unable to display Chinese characters, where you need to enter MySQL each time, set a system parameters "set names GBK", To resolve the problem, ClickNext and continue with the configuration, as you can see:

the , select whether to install MySQL as a Windows service on the page that opens, and also specify the service name, which adds the MySQL Bin folder to Windows PATH will be able to directly use the file under the bin without pointing out the folder name, for example, the connection,"mysql–u username –p password; " then click "Next" to continue with the configuration, as seen in:

- , in the open page, set whether to change the default root user (password),"New root password" , assuming that you want to change, fill in the new password here, and enable the root remote access feature, do not create anonymous users, click "Next" to continue the configuration, see:

- , all the configuration operations are complete here, click Execute button torun the configuration, see:

- , after a few minutes, appear for example the following prompt interface on behalf of the MySQL configuration has ended, and prompted the success of the information.

+ , start the MySQL database in the service, and enter "MySQL–h localhost –u root-p" in the command form or "Mysql-h Localhost-uroot-ppassword", then enter the user's password in the prompt that appears, see:

Be able to see the MySQL database after the launch, the successful login, where we can operate the database.