Mysql graphic installation tutorial (detailed description)

Mysql http://www.jb51.net/softs/2193.html

The following is an example of MySQL installation. It is installed using an executable file! Open the mysqlinstallation file mysql-5.0.27-win32.zip, decompress the file, and run setup.exe. The following page is displayed: www.2cto.com
 
Mysql installation graphic tutorial 1mysql Installation Wizard started, press Next to continue www.2cto.com
For mysql graphic installation tutorial 2, select the installation type, which has three options: Typical (default), Complete (Complete), and m (User-Defined). We choose Custom, which has more options, you can also familiarize yourself with the installation process:
Mysql graphic installation tutorial 3 on Developer Components (Developer part) left-click, select This feature, and all subfeatures, will be installed on local hard drive ., this part and its sub-parts are all installed on the local hard disk. This is also true for MySQL Server, Client Programs, and Documentation to ensure that all files are installed. Click Change... to manually specify the installation directory. Www.2cto.com
Mysql graphic installation tutorial 4 fill in the installation directory. my options are F: \ Server \ MySQL Server 5.0. We recommend that you do not place them in the same partition as the operating system, this prevents data from being cleared during system backup and restoration. Press OK to continue.
Mysql graphic installation tutorial 5: return to the previous page and press Next to continue
Mysql text installation tutorial 6 check the previous settings. If any errors occur, press Back to return and redo. Press Install to start installation.
Mysql graphic installation tutorial 7 is being installed. Please wait until the following interface appears
Mysql text and text installation tutorial 8 here is to ask if you want to register an account for mysql.com, or use an existing account to log on to mysql.com. Generally, this is not required. Click Skip Sign-Up, click Next to skip this step.
Mysql text installation tutorial 9 now software installation is complete, the above interface appears, there is a good function, mysql Configuration Wizard, do not use the same as before, their own mess configuration my. ini, check the Configure the Mysql Server now, and click Finish to complete the software installation and start the mysql Configuration Wizard.
Mysql text installation tutorial 10mysql Configuration Wizard start interface, press Next to continue
Mysql text installation tutorial 10 select the Configuration method, Detailed Configuration (manual precise Configuration), Standard Configuration (Standard Configuration), we choose Detailed Configuration to familiarize yourself with the Configuration process.
Mysql text installation tutorial 11 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 choose according to your own type, generally select Server Machine, not too small, not full.
Mysql graphic installation tutorial 12 select the general purpose of mysql Database, Multifunctional Database (general multi-function type, good), Transactional Database Only (server type, focus 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 ), I chose it with my own purpose. Here I select Transactional Database Only and press Next to continue.
Mysql graphic installation tutorial 13 configure InnoDB Tablespace, that 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. Of course, it is okay to back up the database. We will not detail it here. I have not modified it here. Use the default position and press Next to continue.
Mysql graphic installation tutorial 14 select the average mysql access volume of 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), here I choose Online Transaction Processing (OLTP), your server should be enough, press Next to continue
Mysql text and text installation tutorial 15 whether to enable TCP/IP connection and set the port. If it is not enabled, you can only access the mysql database on your own machine. I will enable it here, check the preceding Port Number: 3306. on this page, you can also Enable the standard Mode so that MySQL does 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
Mysql text and text installation tutorial 16 West text encoding, the second is multi-byte universal utf8 encoding, are not our general encoding, Here select the third, then select or fill in 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. (You can 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, Chinese characters cannot be displayed normally. Press Next to continue.
Mysql text and text installation tutorial 17 select whether to install mysql as a windows Service, you can also specify the Service Name (Service ID Name ), whether to add the bin directory of mysql to Windows Guest-uusername-ppassword.pdf. The complete address of mysql.exe is displayed, which is very convenient.) I checked all the items here and kept the Service Name unchanged. Press Next to continue. Select whether to install mysql as a windows Service. You can also specify the Service Name (Service ID Name) and add the mysql bin directory to Windows Kernel-uusername-ppassword.pdf. Then, the complete address of mysql.exe is displayed, it is very convenient), I have checked all of them here, and the Service Name remains unchanged. Press Next to continue.
Mysql graphic installation tutorial 18 this step asks if you want to modify the default root user (Super Management) password (default is empty), New root password if you want to modify, 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 box before Modify Security Settings, after the installation and configuration are complete, change the password again), and enter Confirm again to prevent errors. Enable root access from remote machines ). Create An Anonymous Account (Create An Anonymous user, and the Anonymous user can connect to the database, and cannot operate data, including queries). Generally, you do not need to check the Account. After setting the Account, press Next to continue.
Mysql text installation tutorial 19 confirm that the settings are correct. If there is an error, press Back to return and check. Press Execute to make the settings take effect.
Mysql text and text installation tutorial 20 is complete, and press Finish to end mysql installation and configuration-a common error is that the Start service is not allowed, it usually appears on the 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 above steps are followed, check whether the previous password has been modified. If not, back up the data folder in the mysql installation directory and delete it. After the installation is complete, delete the data folder generated by the installation, move the backup data folder back, and restart the mysql service. In this case, you may need to check the database and fix it once, prevents data errors.