Shulou(Shulou.com)05/31 Report--

Editor to share with you how to install MySQL5.0 under windows, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Tools / raw materials

MySQL installer: mysql-5.0.38-win32.msi

Steps / methods

one

Open the downloaded installation file and the following interface appears:

two

The mysql installation wizard starts, click "next" to continue.

three

Choose the installation type, there are "Typical", "Complete", "Custom" three options, we choose "Custom", there are more options, but also easy to be familiar with the installation process.

four

Left-click on "MySQL Server (MySQL server)" and select "This feature, and all subfeatures, will be installed on local hard drive.", that is, "this section, and its subordinate subsections, are all installed on the local hard drive". Click "Change..." to specify the installation directory manually.

five

Confirm the previous settings. If there is any error, press "Back" to return to redo. Press "Install" to start installation.

six

Please wait while installation is under way until the interface below appears.

seven

Click "next" to continue, and the following interface appears.

eight

Now the software installation is complete, the above interface appears, there is a good function here, mysql configuration wizard, do not have to manually configure my.ini as before, check the front of "Configure the Mysql Server now", click "Finish" to end the software installation and start the mysql configuration wizard.

nine

Click "Finsh", the following interface appears, and the MySQL Server configuration wizard starts.

ten

Click "next" to display the following interface:

eleven

Choose the configuration method, "Detailed Configuration (manual precise configuration)", "Standard Configuration (standard configuration)", we choose "Detailed Configuration" to facilitate familiarity with the configuration process.

twelve

Select the server type, "Developer Machine (development and test class, mysql takes up very few resources)", "Server Machine (server type, mysql takes up more resources)", "Dedicated MySQL Server Machine (dedicated database server, mysql takes up all available resources)", we choose according to their own type, generally choose "Server Machine", will not be too little, will not be full.

thirteen

Select the general use of the mysql database, "Multifunctional Database (universal multi-functional, good)", "Transactional Database Only (server type, focus on transaction processing, general)", "Non-Transactional Database Only (non-transaction type, simple, mainly do some monitoring, counting, support for MyISAM data types is limited to non-transactional), choose as your own use, I choose" Transactional Database Only "here, press" Next "to continue.

fourteen

To configure InnoDB Tablespace is to select a storage space for the InnoDB database file. If you modify it, remember the location and choose the same place when reinstalling, otherwise the database may be damaged. Of course, it will be no problem to make a backup of the database, which will not be detailed here. I did not modify it here, use the default location and press "Next" to continue.

fifteen

Select the general number of mysql visits to your website, and the number of connections at the same time, "Decision Support (DSS) / OLAP (about 20)", "Online Transaction Processing (OLTP) (about 500s)", "Manual Setting (manually set up, enter a number by yourself)", I choose "Online Transaction Processing (OLTP)" here, your own server should be enough, press "Next" to continue.

sixteen

Whether to enable the TCP/IP connection, set the port, if not, you can only access the mysql database on your own machine. I enable it here, check the previous box, Port Number:3306, on this page, you can also select "enable standard mode" Enable Strict Mode), so that MySQL will not allow minor syntax errors. If you are still a novice, I suggest you cancel the standard mode to reduce hassle. However, once you are familiar with MySQL, try to use standard mode because it reduces the possibility of harmful data entering the database. There is also a setting about the firewall "Add firewall exception." You need to select to add the listening port of the MYSQL service as an exception to the windows firewall to avoid firewall blocking. Press "Next" to continue.

seventeen

Note: if you want to use the data from the original database, it is best to determine what code is used in the original database. If the encoding set here is inconsistent with the encoding of the original database data, garbled code may occur when using it. This is more important, that is, to set the default database language code of mysql. The first is a western language code, and the second is a multi-byte universal utf8 code, which is not our common code. Choose the third one here, and then select or fill in "gbk" in Character Set. Of course, you can also use "gb2312". The difference is that gbk has a large font capacity, including all the Chinese characters in gb2312. And add traditional Chinese characters, and other messy words-when using mysql, run "SET NAMES GBK" once before executing the data manipulation command "(just run it once, GBK can be replaced with other values, depending on the settings here), you can use Chinese characters (or other characters) normally, otherwise you can't display Chinese characters normally. Press "Next" to continue.

eighteen

Choose whether to install mysql as a windows service, you can also specify Service Name (service identification name), and whether to add the bin directory of mysql to Windows PATH (after joining, you can directly use the files under bin without indicating the directory name, such as connection, "mysql.exe-uusername-ppassword;", do not point out the full address of mysql.exe, very convenient), I have all checked here, Service Name remains unchanged. Press "Next" to continue.

nineteen

This step asks if you want to change the password of the default root user (Super Administration) (empty by default). If you want to modify "New root password", fill in the new password here (if it is reinstalled and the password has been set before, it may make an error to change the password here, please leave it blank, uncheck the box before "Modify Security Settings", and change the password again after installation and configuration), and fill in "Confirm" again. Avoid losing mistakes. " Enable root access from remotemachines (whether to allow root users to log in on other machines, do not check it if it is safe, and check it if it is convenient). Finally, "Create An Anonymous Account (create an anonymous user, anonymous users can connect to the database, can not manipulate data, including queries)", generally do not need to check, set up, press "Next" to continue.

twenty

Confirm that the settings are correct. If there is any error, press "Back" to return to the check. Press "Execute" to make the setting effective. After setting up, press "Finish" to end the installation and configuration of mysql.

END

Matters needing attention

There is a common error here, that is, it cannot be "Startservice". It generally appears on servers where mysql has been installed before. The solution is to make sure that the previously installed mysql server is completely uninstalled; if not, check whether the previous password has been changed as described in the above step, and follow the above operation. If it still fails, back up the data folder under the mysql installation directory, and then delete it. After the installation is complete, delete the data folder generated by the installation, move the backup data folder back, and then restart the mysql service. In this case, you may need to check the database and repair it again to prevent data errors.

The above is all the contents of the article "how to install MySQL5.0 under windows". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.