Detailed installation of MySQL5.5.27 (pictures and text)

This article introduces to you the installation tutorial of mysql 5.5.27 in the form of pictures and texts. It is very good and has reference value. Friends who need it can refer to it

1. MYSQL Installation

1. Open the downloaded mysql installation file mysql-5.5.27-win32.zip, double-click to decompress, and run "setup.exe"

2. Select the installation type, including "Typical (default)", "Complete (complete)", and "Custom (user-defined)" Three options, select "Custom", press the "next" key to continue

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

4. Fill in the installation directory. Mine is "F:\Server\MySQL\MySQLServer 5.0". It is recommended not to put it in the same partition as the operating system. This can prevent system backup. When restoring, the data is cleared. Press "OK" to continue.

#Confirm the previous settings. If there are errors, press "Back" to return and redo. Press "Install" to start the installation.

# 5. Installation is in progress, please wait until When the following interface appears, the installation of MYSQL is completed

## 2. MYSQL configuration1. After the installation is completed, the following interface will appear and you will enter the mysql configuration wizard.

2. Select the configuration method, "DetailedConfiguration (manual precise configuration)", "Standard Configuration (standard Configuration)", we select "Detailed Configuration" to facilitate familiarity with the configuration process

3. Select the server type, "DeveloperMachine (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)"

４. Select the general purpose of the mysql database, "MultifunctionalDatabase (general multifunctional, good)", "TransactionalDatabase Only (server type, focused on transaction processing, general)", "Non-Transactional Database Only (non-transactional) , relatively simple, mainly used for monitoring and counting. 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, the number of simultaneous connections, "DecisionSupport (DSS)/OLAP (about 20)", "Online Transaction Processing (OLTP) (about 500)", "Manual Setting (manual setting, enter it yourself) A number)".

６. Whether to enable TCP/IP connection and set the port. If not enabled, you can only access the mysql database on your own machine. On this page, you can also select "Enable Strict Mode" Mode) so that MySQL will not allow minor syntax errors. If you are a newbie, it is recommended that you cancel the standard mode to reduce trouble. But after becoming 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. Set the default database language encoding of mysql (important). Generally, UTF-8 is selected. Press "Next" to continue.

8. Choose whether to install mysql as a windows service. You can also specify ServiceName (service identification name) and whether to add the bin directory of mysql to WindowsPATH (add After that, you can directly use the file under bin without pointing out the directory name. For example, to connect, "mysql.exe-username -ppassword;" is enough. You don't need to point out the full address of mysql.exe, which is very convenient). I have all of them here When checked, ServiceName remains unchanged. Press "Next" to continue.

#9. Ask if you want to change the password of the default root user (super administrator). "Enable root access from remote machines (whether to allow root users to log in on other machines, if you want security, don't check it, if you want convenience, check it)". Finally, "Create An Anonymous Account (create a new anonymous user, anonymous users can connect to the database, but cannot operate data, including queries)". Generally, there is no need to check it. After the settings are completed, press "Next" to continue.

10. Confirm that the settings are correct, and press "Execute" to make the settings take effect. This completes the installation and configuration of MYSQL.

Note: After the setting is completed, there is a common error after pressing "Finish", that is, it cannot be " Startservice" usually appears on servers where MySQL has been installed before. The solution is to first ensure that the previously installed MySQL server is completely uninstalled; if not, check whether the previous password has been modified as mentioned in the step above. Follow the instructions above. If it still doesn't work, back up the data folder in the mysql installation directory and delete it. After the installation is completed, delete the data folder generated by the installation, move the backed up data folder back, and then restart the mysql service. , in this case, you may need to check the database and then repair it to prevent data errors.

Solution:

1, uninstall MySQL

2, WindowsXp system Delete the directory C:\Documents and Settings\All Users\Application Data\

windows 7\8\10 operating system. Delete the directory C:\ProgramData\MySQL

3. Just reinstall it.

Summarize

The above is the detailed content of Detailed installation of MySQL5.5.27 (pictures and text). For more information, please follow other related articles on the PHP Chinese website!