MySQL 5.0 and mysql 5.0

MySQL 5.0 and mysql 5.0

1. Select next:

2. Select Custom. Among them, "Typical (default)", "Complete (Complete)", and "Custom (Custom )":

3. Click "component components (developer part)" and select "This feature, and all subfeatures, will be installed on local harddrive. ", that is," This part and its sub-parts are all installed on the local hard disk ". "MySQL Server", "Client Programs (mysql Client program)", and "Documentation )".

4. Click "Change..." and manually specify the installation directory:

5. We recommend that you do not place data in the same partition as the operating system to prevent data from being cleared during system backup and Restoration:

6. Ask if you want to register an account for mysql.com or log on to mysql.com with an existing account. Generally, if you do not have an account, click "Skip Sign-Up:

7. Check "Configure the MysqlServer now" and select the mysql Configuration Wizard:

8. Click next:

9. "DetailedConfiguration" and "Standard Configuration )". Select "DetailedConfiguration ":

10. Select the Server type: "development Machine (Development test class, mysql occupies a small amount of resources)" and "Server Machine (Server type, mysql occupies a large amount of resources) "," Dedicated MySQL Server Machine (Dedicated database Server, mysql occupies all available resources), here I choose: Developer Machine.

11. Here is the general usage of the mysql Database, "MultifunctionalDatabase (general multi-function type, good)" and "Transactional Database Only (server type, focusing on transaction processing, General) "," Non-TransactionalDatabase Only (non-transaction processing type, relatively simple, mainly used for monitoring and recording, the support for MyISAM data type is limited to Non-transactional ). As needed, I chose Transactional Database Only:

12. configuring InnoDB Tablespace is to select a bucket for the InnoDB database file. If you modify it, remember the location and select the same place during reinstallation, otherwise, the database may be damaged. Do not modify it here. Directly next:

13. Select the General mysql access volume and the number of connections for the created website, such as "DecisionSupport (DSS)/OLAP (about 20)" and "Online Transaction Processing (OLTP) (about 500) "," ManualSetting (manually set, enter a number by yourself )". Based on my needs, I chose the first item:

14. Whether to enable the TCP/IP connection. If enabled, set the Port and check the Port Number 3306. If not, you can only access the mysql database on your machine. I set the port as needed. In addition, you can select Enable Strict Mode, so that MySQL will not allow small syntax errors. However, if you are a newbie, we recommend that you cancel the standard mode to reduce the trouble. However, if you are familiar with MySQL, try to use the standard mode because it can reduce the possibility of harmful data entering the database.

15. The second is multi-byte universal utf8 encoding, which is not our general encoding. Here we select the third encoding, and then select or enter "gbk" in Character Set ", of course, you can also use "gb2312", the difference is that the gbk font capacity is large, including all the Chinese characters of gb2312, and added traditional Chinese characters, and other messy words. When using mysql, run "set names gbk;" once before executing the data operation command (just run it once. You can replace GBK with other values, depending on the settings here), you can use Chinese characters or other texts normally. Otherwise, the Chinese characters cannot be displayed normally.

16. Select whether to install mysql as a windows Service, specify ServiceName (service ID name), and add the mysql bin directory to the full address of Windows Firewall ). Select as follows:

17. In this step, check whether you want to change the password of the default root user (Super Management) (empty by default). If you want to change the "New root password, enter the new password here (if you have already set a new password, changing the password may cause an error. leave it blank and remove the check mark before "Modify Security Settings, after the installation and configuration are complete, change the password.) Enter "Confirm" again to prevent errors. "Enable root access from remote machines (whether to allow root users to log on to other machines. If you want security, do not check it. If you want convenience, check it )". Finally, "Create An Anonymous Account (Create An Anonymous user. An Anonymous user can connect to the data and cannot perform operations on the data, including queries )".

18. Check whether the settings are correct. If the settings are correct, press "Back" to return the check; otherwise, press "Execute" to take effect.

Summary:Since then, I have installed a relatively high version of MySQL. In comparison, it seems that it is easier to install a higher version. Maybe this is the improvement that serves the people wholeheartedly, please wait for the next article to introduce the installation operations for later versions!