MySQL study Notes-MySQL installation (2) _ MySQL

Source: Internet
Author: User
Note: Here is a configuration wizard option (ConfiguretheMySQLServernow). We recommend that you check to configure your MySQL immediately. Many say that MySQL cannot be started after installation, because MySQL is not configured. Click "Finish" to complete the installation and start configuring MySQL, as shown in. 9 .. Click "Next" to go to the configuration type selection page. Install mysql


Note: Here is a configuration wizard option (Configure the MySQL Server now). We recommend that you check to Configure your MySQL immediately. Many say that MySQL cannot be started after installation, because MySQL is not configured. Click "Finish" to complete the installation and start configuring MySQL, as shown in. 9.
   
. 9
  
Click "Next" to go to the configuration type selection page. Select "Detailed configuration" (Detailed configuration), as shown in. 10.
   
. 10
  
Click "Next" to go to the service type selection page. Select "Developer Machine" (Developer Machine) to consume less system resources. for details, see. 11.
   
. 11
  
Click "Next" to go to the database usage selection page. Select "Multifunctional Database", as shown in. 12.
   
. 12
  
Click "Next" to go to the InnoDB data storage location selection page, as shown in. 13.
   
. 13
  
You do not need to change the settings, just put them in the Installation directory of Installation Path, and click "Next" to select the number of simultaneous connections of MySQL, as shown in. 14.
   
. 14
  
Select Manual Setting and set it to 100 (as required). click "Next" to configure the port of MySQL in the TCP/IP communication environment. for details, see. 15.
   
. 15
  
Select the default 3306 port. Click "Next" and select character settings in MySQL, as shown in. 16.
   
. 16
  
Note that the selection will affect whether you can use Chinese in MySQL. We select the gb2312 character set to support Simplified Chinese and big5 for traditional Chinese. Click "Next" to set Windows service options, as shown in. 17.
   
. 17
  
Note that the selection here is critical. You must check "Install As Windows Service" to run MySQL As a Windows Service. "Service Name" uses the default "MySQL" or your favorite Service Name (the default "MySQL" is recommended "). The following "Launch the MySQL Server automatically" must be checked, so that MySQL will automatically start the service during Windows startup, or you will have to manually start MySQL. Many people say that MySQL cannot be started, cannot be connected, and a 10061 error occurs after it is installed. this is the reason. Click "Next" to set the root account's logon password, as shown in. 18.
   
. 18
  
"Modify Security Settings" is used to set the password of the root account. enter the password you set. "Create An Anonymous Account" is used to Create An Anonymous Account. this will cause unauthorized users to access your database illegally. it is recommended that you do not select this option because of security risks. Click "Next". the MySQL Configuration Wizard configures MySQL based on all the settings above, so that MySQL runs as needed. See. 19.
   
. 19
  
Click "Execute" to start configuration. when "Service started successfully" is displayed, it indicates that your configuration is complete and the MySQL Service is started successfully. 20.
  
. 20
  
Click "Finish" to complete the configuration of MySQL. The rest is to connect to the MySQL server using the MySQL client and then use it.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.