MySQL 5.5.21 installation in Windows 7

We all know that MySQL is a small and medium-sized relational database management system. It is very practical and helpful for us to learn a lot of technologies. I installed SQL Server 2008 and Oracle 10g databases separately a few days ago, JDBC is also used to connect them, and no garbled code is displayed. Yesterday, when I saw a garbled code when I used java to connect to the MySQL database, I did not know it. I immediately went online to check the JDBC connection to MySQL, it is found that when you connect to the MySQL database using JDBC, you must pass a parameter that can solve the garbled characters before you can insert data that is not garbled into the database.

This is one of the reasons why I want to install the MySQL database. I would like to try the following: in addition, the configuration of the machine in the course is relatively low. It is the best choice to install the MySQL database for experiments, I installed MySQL for these two reasons. During the installation process, I noticed some problems. During the installation process, I cut down the steps, I hope to help anyone who needs it. My database version is 5.5.21. Follow these steps:
1. First, click the Installation File of MySQL5.5.21. The installation wizard interface for this database appears. Click "next" to continue the installation ,:
2. In the window that appears, Select accept the installation protocol and click "next" to continue the installation ,:
3. In the installation type selection window, there are three options: "typical (default)", "Complete (Complete)", and "Custom (Custom, we chose "Custom", because Custom settings allow us to familiarize ourselves with the installation process and click "next" to continue the installation ,:
4. On the displayed custom installation page, select the mysql database installation path. Here, I set "d: \ Program File \ MySQL" and click "next" to continue the installation ,:
5. Next, go to the installation preparation page. First, confirm the previous settings. If there is an error, press "back" to return. If there is no error, click "Install" to continue the installation ,:
 
6. After clicking the "Install" button, the following page is displayed ,:
 
Click "next" on this page.
 
 
Select the "Launch the MySQL Instance Configuration Wizard" option above. This is the Configuration for starting MySQL. Click "Finish" to go to the Configuration page. 7. The installation of the MySQL database is very simple. The key is the configuration after the installation is complete. After you click Finish, the following Configuration Wizard appears. Click "next" to configure the database ,:
 
8. In the Open Configuration type window, select the Configuration method, "Detailed Configuration (manual precise Configuration)" and "Standard Configuration (Standard Configuration)". To familiarize yourself with the process, select "Detailed Configuration (manual precise Configuration)" and click "next" to continue ,:
 
9. In the displayed window, select the Server type, such as Developer Machine and Server Machine) "," Dedicated MySQL Server Machine (Dedicated database Server) ", we only want to learn and test, by default, click" next "to continue ,:
 
10. On the displayed configuration page, select the mysql Database usage, such as "Multifunctional Database (Universal multi-function type)" and "Transactional Database Only (server type) "," Non-Transactional Database Only (Non-transaction processing type) ", here I select the first item, general installation, click" next "to continue the configuration ,:
 
11. On the page that appears, configure InnoDB Tablespace to select a bucket for the InnoDB database file. If it is modified, remember the location, you must select the same place during reinstallation. Otherwise, database damage may occur. Of course, it is okay to back up the database ,:
 
12. On the displayed page, select the mysql access volume and the number of connections at the same time. For example, "demo-support (DSS)/OLAP (about 20)" and "Online Transaction Processing (OLTP) (about 500), Manual Setting (Manual Setting, set to 15) Here select Manual Setting, click "next" to continue ,:
 
13. On the open page, set whether to enable the TCP/IP connection and set the port. If the port is not enabled, you can only access the mysql database on your own machine, this is also an operation to connect to java. The default port is 3306, and strict syntax settings are enabled. Click "next" to continue ,:
 
14. On the character encoding page that is opened, set the character encoding to be used by mysql. The first is Spanish encoding, the second is multi-byte universal utf8 encoding, and the third is manual, select UTF-8 or gbk and click "next" to continue configuration ,:
 
15. On the displayed page, select whether to install mysql as a windows Service. You can also specify the Service Name (Service ID Name ), whether to add the bin directory of mysql to Windows PATH (after adding it, You can directly use the file under bin without specifying the directory name, such as connection, "mysql-u username-p password;", click "next" to continue the configuration ,:
 
16. On the displayed page, set whether to modify the password of the default root user (Super administrator) (empty by default) and "New root password". If you want to modify the password, enter the new password here and enable the root remote access function. Do not create anonymous users. Click "next" to continue the configuration ,:
 
17. All configuration operations have been completed. Click Execute to Execute the configuration ,:
 
18. After a few minutes, the following prompt appears, indicating that the MySQL configuration is complete and the prompt is displayed.
 
19. Start the mysql database in the service, enter "mysql-h localhost-u root-p" in the Command window, and enter the user password in the prompt ,:
We can see that the mysql database is successfully logged on after it is started. Here we can operate on the database.