MySQL 5.5 installation configuration simple tutorial _mysql

The following is the MySQL installation process, with the executable file installed, detailed description of a bit!

1. Open the download MySQL installation file mysql-5.0.27-win32.zip, double-click decompression , run "setup.exe"

2.mysql Setup Wizard started, Press "Next" to continue to choose the installation type , there are "typical (default)", "Complete (Full)", "Custom (user-defined)" Three options, we choose "Custom" , there are more options, but also easy to familiarize yourself with the installation process.

3. On the "Developer components (developer part)" Left-click, select "This feature, and all subfeatures, will is installed on the local hard drive.", that is, "this part, and subordinate part of the content, all installed on the local hard drive. This is done on the MySQL server (MySQL servers), client Programs (MySQL client), and documentation (documentation) to ensure that all files are installed. Click Change ... to manually specify the installation directory.

Fill in the installation directory, my is "F:\Server\MySQL\MySQL Server 5.0", also recommended not to be placed in the same partition as the operating system, so as to prevent the system backup restore time, the data is emptied. Press "OK" to continue.

4. Return to the interface just now and press "Next" to continue.

Confirm the previous settings and, if wrong, press "back" to redo. Press "Install" to start the installation.

In the installation, please wait until it appears here is to ask you whether you want to register a mysql.com account, or use the existing account login mysql.com, generally do not need, click "Skip Sign-up", press "Next" skip this step.

5. Now the software installation is complete, here is a very good function, theMysql Configuration Wizard, not to the same as before, their own manual mess configuration My.ini, will "Configure the Mysql Server now" in front of the tick, point " Finish "End the software installation and start the MySQL Configuration Wizard."

6.mysql Configuration Wizard to start the interface, press "Next" to continue.

Select the configuration mode, "Detailed Configuration (Manual precise configuration)", "Standard Configuration (Standard configuration)", we choose "Detailed Configuration" to facilitate familiarity with the configuration process.

7. Select the server type, " Developer Machine (Development test class, MySQL takes up very little resources), "Server Machine (server type, MySQL occupies more resources)", "dedicated MySQL server Machine (Specialized database server , MySQL occupies all available resources) ", we choose according to their own type, the general election of"Server Machine", not too little, will not fill. My choice here is Developer Machine.

8. Choose the approximate use of MySQL database , "Multifunctional db (Universal multi-function, good)", "Transactional database only (server type, focus on transaction, General)", " Non-transactional Database only (non-transactional processing type, simpler, mainly to do some monitoring, counting, MyISAM data types of support limited to non-transactional), with their own use and choice, I choose "Mu ltifunctional Database".

9. Whether to enable TCP/IP connection, set the port , if not enabled, you can only access the MySQL database on their own machine, I am enabled here, the front of the tick, Port number:3306, on this page, you can also choose "Enable Standard mode" (Enable Strict Mode) so that MySQL does not allow for minor grammatical errors. If you are still a novice, I recommend that you cancel the standard mode to reduce the hassle. But after familiarity with MySQL, use standard mode as much as possible, because it reduces the likelihood that harmful data will enter the database. Press "Next" to continue

10. This is more important, is the MySQL default database language encoding settings, the first is the western code, the second is multibyte universal UTF8 encoding, is not our common code, here Select the third, and then in the character set where Select or fill in " GBK ", of course, can also use" gb2312 ", the difference is GBK's font size, including all the gb2312 of Chinese characters, and the addition of traditional characters, and other messy words-when using MySQL, in the execution of data Operation command before the" SET NAMES GBK; " (Run once on the line, GBK can be replaced by other values, depending on the settings here), you can normally use Chinese characters (or other text), otherwise can not display Chinese characters normally. I choose "gb2312" here, press "Next" to continue.

11. Choose whether to install MySQL as a Windows service , or specify the service name (the name of the services identity), and whether to add MySQL's Bin directory to Windows PATH (after joining, you can use the files under bin directly, Instead of pointing to directory names, such as connections, "Mysql.exe-uusername-ppassword;" On it, do not point out the full address of mysql.exe, very convenient, I have all ticked here, Service name unchanged. Press "Next" to continue.

12. This step asks if you want to modify the default root user (super Admin) password (default is null), "New root password" If you want to modify it, fill in the fresh password (if it is a reload, and the password has been set before, there may be an error in changing the password here. Please leave blank, and the "Modify security Settings" Before the check out, the installation configuration is completed after a separate change password), "Confirm (again)" to fill in again, to prevent the wrong loss. "Enable root access from remote machines (whether or not to allow root users to log on to other machines, if you want to be safe, do not hook, if it is convenient to hook it up)". Finally "Create a Anonymous account (a new anonymous user, anonymous users can connect to the database, cannot manipulate data, including queries)", generally do not have to tick, set up, press "Next" to continue.

13. Verify that the settings are correct, if wrong, press "back" to return to check. Press ' Execute ' to make the settings effective.

Set up, press "Finish" to end the installation and configuration of MySQL--here is a more common mistake, is not "Start service", generally appear in the previous installation of MySQL server, the solution, first of all, to ensure that the MySQL server installed before the total uninstall off the , if not, check to see if the previous password has been modified according to the above, the operation above; if still not, the MySQL installation directory of the Data folder backup, and then deleted, after the installation is completed, will install the generated Data folder deleted, the backup of the data folder to move back, Restart the MySQL service, in which case you may need to check the database and fix it once to prevent data errors.

Set environment variable!

Press "Next" to continue.

InnoDB tablespace configuration, is to InnoDB database files to choose a storage space, if modified, to remember the location, when reloading to choose the same place, otherwise it may cause database damage, of course, to do a backup of the database is no problem, here is not detailed. I have not modified here, use the default location, directly press "Next" to continue to select your site's general MySQL access, the number of simultaneous connections, "Decision Support (DSS)/olap (20)", "Online Transaction Processing (OLTP) (500 or so), "Manual Setting (manually set, lose one number)", I Choose "Decision Support (DSS)/olap)", press "Next" to continue.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.