Mysql 5.5 installation and configuration simple tutorial, mysql5.5

Mysql 5.5 installation and configuration simple tutorial, mysql5.5

The following is the MySQL installation process. It is installed using an executable file!

1. Open the downloaded mysql Installation FileMysql-5.0.27-win32.zip, double-clickExtractRun the “setup.exe"

2. Start the mysql Installation Wizard,Press "Next" to continue SelectionInstallation typeThere are three options: "Typical (default)", "Complete (Complete)", and "Custom (Custom)". We choose "Custom" and there are more options, you can also familiarize yourself with the installation process.

3. click "Developer Components (Developer part)" and select "This feature, and all subfeatures, will be installed on local hard drive. ", that is," This part and its sub-parts are all installed on the local hard disk ". The preceding operations include "MySQL Server", "Client Programs (mysql Client program)", and "Documentation (document)" to ensure that all files are installed. Click "Change..." and manually specify the installation directory.

Fill in the installation directory "F: \ Server \ MySQL Server 5.0", and do not place it in the same partition as the operating system. This prevents system backup and restoration, data is cleared. Press "OK" to continue.

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

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

The installation is in progress. Please wait until you have registered an account named mysql.com or logged on to mysql.com using an existing account, click "Skip Sign-Up" and click "Next" to Skip this step.

5. Now the software has been installed. Here is a good function,Mysql Configuration Wizard,You do not need to manually configure my. ini. Check the "Configure the Mysql Server now" and click "Finish" to Finish the software installation and start the mysql Configuration Wizard.

6. Start the mysql Configuration Wizard and press "Next" to continue.

Select the Configuration method, "Detailed Configuration (manual precise Configuration)", and "Standard Configuration". Select "Detailed Configuration" to familiarize yourself with the Configuration process.

7. Select the server type,"Developer Machine (development and testing class, mysql occupies a small amount of resources) "," Server Machine (Server type, mysql occupies a large amount of resources) "," Dedicated MySQL Server Machine (Dedicated database Server, mysql occupies all available resources) ". You have chosen this option based on your type. Generally, select" Server Machine ", which is neither too small nor full. Developer Machine is selected here.

8. Select the general usage of the mysql database, "Multifunctional Database (general multi-function type, good)", "Transactional Database Only (server type, dedicated to transaction processing, General) "," Non-Transactional Database Only (non-transaction processing type, relatively simple, mainly used for monitoring and recording, the support for MyISAM data types is limited to Non-transactional ), I chose it based on my own purpose. Here I select "Multifunctional Database ".

9. Whether to enable TCP/IP connection and set the portIf it is not enabled, you can only access the mysql database on your own machine. I will enable it here and mark the previous one with Port Number: 3306. on this page, you can also select Enable Strict Mode, so that MySQL will not allow small syntax errors. If you are a newbie, I suggest 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. Press "Next" to continue

10. This is important,It is to set the default mysql database language encoding. The first is the Spanish encoding, and the second is the multi-byte universal utf8 encoding, which is not our general encoding. Here we select the third, then select or fill in "gbk" in the Character Set. Of course, you can also use "gb2312". The difference is that the gbk font size is large, including all Chinese characters of gb2312, and added traditional Chinese characters and other messy words-when using mysql, Run "set names gbk;" before executing the data operation command (just run it once, GBK can be replaced 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. Select "gb2312" here and press "Next" to continue.

11. Select whether to install mysql as a windows ServiceYou can also specify the Service Name (Service ID Name) to check whether the bin directory of mysql is added to Windows Kernel-uusername-ppasswordtail.exe. The complete address of mysql.exe is displayed, which is very convenient, the Service Name remains unchanged. Press "Next" to continue.

12. In this step, check whether you want to change the password of the default root user (Super Management) (empty by default), "New root password". If you want to modify the password, enter the New password here (if you have already set the password for reinstallation, changing the password here may cause an error. leave it blank, remove the check box before "Modify Security Settings" and change the password after the installation and configuration is complete.) enter the check box in "Confirm" 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, and the Anonymous user can connect to the database, and cannot operate data, including queries)" is not checked. The settings are complete, press "Next" to continue.

13. confirm that the settings are correct.If any error occurs, press "Back" to return the check result. Press Execute to make the settings take effect.

After the configuration is complete, press "Finish" to end mysql installation and configuration. Here is a common error, that is, the "Start service" is not allowed, which usually appears on a server where mysql was previously installed, to solve this problem, first ensure that the previously installed mysql server is completely uninstalled. If not, check whether the previous password has been modified as described in the previous step; if not, back up the data folder under the mysql installation directory and delete it. After the installation is complete, delete the data folder generated by the installation and remove the backed up data folder, restart the mysql service. In this case, you may need to check the database and fix it once to prevent data errors.

Set environment variables!

Press "Next" to continue.

Configure InnoDB Tablespace to select a bucket for the InnoDB database file. If you modify the bucket, remember the location and select the same place for the reinstallation. Otherwise, the database may be damaged, of course, it is okay to back up the database. We will not detail it here. I didn't modify it here. I used the default location to directly press "Next" to continue to select the General mysql access volume for your website, and the number of connections at the same time, "demo-support (DSS) /OLAP (about 20) "," Online Transaction Processing (OLTP) (about 500) "," Manual Setting (manually set, input a number by yourself )", select "demo-support (DSS)/OLAP)" here, and press "Next" to continue.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.