Recently to test the certificate, the use of MySQL, and then to the system to organize learning, usually work with a lot, relatively scattered. 1. Follow the software:Windows (x86, 32-bit), MySQL server5.1:Http://dev.mysql.com/downloads/installer/5.6.html 2. Steps: (1) As with other Windows installers, the next step is to
(2)3 types: Typical (typical), complete (full), custom (customized). Select "Custom" to install, then click "Next" Next, the Custom installation interface appears
(3) After installation, the explanation screen appears, the next step, to the following page:
-There is a configuration Wizard option (Configure the MySQL Server now), it is recommended to tick configure your MySQL immediately. Many say that after MySQL is installed, it cannot be started because MySQL is not configured. Click "Finish" to complete the installation and start configuring MySQL
(4) Enter the Configuration Type Selection page. Select "Detailed Configuration" (details)
Description: Standard configuration: For new users wishing to start MySQL quickly without regard to server configuration;
detailed configuration: For advanced users who require finer granularity in controlling server configuration.
(5) Then,Click "Next" to enter the service Type Selection page. Choose "Developer Machine" (developer), so that there is not a lot of resources to occupy the system
(6) Click "Next" to enter the database Usage Selection page. Select "Multifunctional database", since the multi-function database is applicable to both InnoDB and My-isam tables, select "Multi-function Databases"
(7) Click "Next", go to select InnoDB Data Storage Location page, you can modify the location of InnoDB, here do not change, next.
(8) Next, go to the Select MySQL for Concurrent Connection selection dialog box interface:
Decision Support: Select this option if the server does not require a large number of parallel connections;--Select this online transaction by default: Select if the server requires a large number of parallel connections; Manual settings: Select this option to manually set the maximum number of server parallel connections. --If you want to change the number of connections, select this
(9) Continue to "Next", configure MySQL port in the TCP/IP communication environment, select the default is to start the TCP/IP network, the default port: 3306
(10) Click "Next", select the MySQL Character Set selection dialog page, there are 3 options, in order to support Chinese, here Select the third: Manual Selected Default Character set/collation, and in Character Select as gb2312 in set
(11) Click "Next", set the Windows service options, here to select the service name default value: MySQL Note that the choice here is critical. "Install as Windowsservice" must be checked, which is to run MySQL as a service for Windows. The "service name" is the default "MySQL" or your preferred service name (the default "MySQL" is recommended). The following "Launch the MySQL Server automatically" must be checked, so that when Windows starts, MySQL will automatically start the service, or you will have to manually start MySQL. Many people say that after installing MySQL it is not possible to start, connect, or have a 10061 error, which is why.
(15)Click "Next" to set the login password of root account, "Modify Security Settings" is to set the root account password, enter the password you set. Create an Anonymous accounts is an anonymous account that causes unauthorized users to access your database illegally, with security implications and not recommended. Select Enable root access from Remte machines if you want to log in as root via the network-allows you to connect to root from Telnet
(16) Click "Next", the MySQL Configuration wizard will configure MySQL based on all of your settings, so that MySQL runs as you need, click Execute here, you can start the MySQL Configuration Wizard execution, until the end.
Note: 1. The following file appears in the installation directory, and you can change some of the default settings for MySQL by modifying this file 2. In addition, in MySQL there is a data directory for storing database files, and in data MySQL creates a folder for each database, and all the table files are stored in the corresponding database folder. In the My.ini file, you can find the storage path of the data file:
From for notes (Wiz)
MySQL Basics-Installation + configuration
