MySQL5.5.27 installation text tutorial, mysql5.5.27 text

Source: Internet
Author: User
Tags root access

MySQL5.5.27 installation text tutorial, mysql5.5.27 text

1. Install MYSQL

1. Open the downloaded mysqlinstallation file mysql-5.5.27-win32.zip, decompress the package, and run “setup.exe"



2. Select "Custom" for "Typical (default)", "Complete (Complete)", and "Custom (Custom ", press "next" to continue


3. Click "Browse" and manually specify the installation directory.


4. Fill in the installation directory "F: \ Server \ MySQL \ MySQLServer 5.0". We recommend that you do not place it in the same partition as the operating system to prevent system backup and restoration, data is cleared. Press "OK" to continue.


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



5. Installing MYSQL. Please wait until the following interface is displayed.

 

Ii. MYSQL Configuration

1. After the installation is complete, the following page appears to go To the mysql Configuration Wizard.


 

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


3. Select the Server type, "Development Machine (Development test 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 )"

 

4. Select the general usage of the mysql database, "MultifunctionalDatabase (general multi-function type, good)" and "TransactionalDatabase Only (server type, focusing on 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 ), press "Next" to continue.


5. Select the number of concurrent connections to the website, including "DecisionSupport (DSS)/OLAP (about 20 connections)" and "Online Transaction Processing (OLTP) (about 500 connections) "," Manual Setting (manually set, input a number by yourself )".



6. Whether to enable the TCP/IP connection and set the port. If the port is not enabled, you can only access the mysql database on your machine. on this page, you can also select Enable Strict Mode, so that MySQL will not allow small syntax errors. 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. Press "Next" to continue


7, is the default mysql database language encoding settings (important), generally select UTF-8, press "Next" to continue.


Your-uusername -ppassword=example can be used to indicate the complete address of mysql.exe, which is very convenient). I have checked all of them here and the ServiceName remains unchanged. Press "Next" to continue.


9. Ask if you want to change the password of the default root user (Super management. "Enable root access fromremote 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.


10. confirm that the settings are correct. Press "Execute" to make the settings take effect. This completes MYSQL installation and configuration.



Note: After the settings are complete, there is a common error after pressing "Finish", that is, the error cannot be "Startservice", which usually appears on the server where mysql was previously installed. The solution is as follows, first, ensure that the previously installed mysql server is completely uninstalled. If not, check whether the previous password has been modified as described above. If not, back up and delete the data folder under the mysql installation directory. After the installation is complete, delete the generated data folder and the backup data folder, restart the mysql service. In this case, you may need to check the database and fix it once to prevent data errors.

Solution:

1. uninstall MySQL

2. in Windows XP, delete the directory C: \ Documents ents and Settings \ All Users \ Application Data \

Windows 7 \ 8 \ 10 Operating System Delete directory C: \ ProgramData \ MySQL

3. reinstall it.

Summary

The above is a graphic installation tutorial on MySQL5.5.27 introduced by xiaobian. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.