Mysql installation illustration mysql graphic installation tutorial (detailed description) _ MySQL

Mysql installation illustration mysql graphic installation tutorial (detailed description) bitsCN.com

The following is an example of MySQL installation. it is installed using an executable file!

Open the mysqlinstallation file mysql-5.5.15-win32.zip, decompress the file, and run “setup.exe. the following interface is displayed:

Start the mysql installation wizard and press "Next" to continue

Press "Next" to continue

Select the installation type, which has three options: "Typical (default)", "Complete (Complete)", and "Custom (Custom)". select "Typical ", the following page is displayed:

Click "install" to continue. the page is displayed:

Press "Next" to continue:

Click "finish" to complete the installation.

Mysql configuration wizard start interface, 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.

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.

Select the average mysql access volume of your website and the number of connections at the same time. for example, "demo-support (DSS)/OLAP (about 20 connections)" and "Online Transaction Processing (OLTP) (about 500) "and" Manual Setting (manually set, enter a number by yourself) ". here I select" Online Transaction Processing (OLTP) "and my server, enough. press "Next" to continue.

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. I enable it here and tick the 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

This is very important. it is to set the default mysql database language encoding. The first is the Spanish encoding, and the second is the multi-byte general utf8 encoding, which is not our general encoding, select the third Character here, and 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 the 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. 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 the Windows kernel-uusername-ppassword##directory. 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.

This step asks if you want to change the default root user (Super management) password (blank by default). If you want to change the "New root password", enter the New password here (if re-installed, you have already set a password. changing the password may cause errors. leave it blank and remove the check box before "Modify Security Settings". after the installation and configuration are complete, change the password separately ), "Confirm (re-enter)" is entered again 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.

Confirm that the settings are correct. if any error occurs, press "Back" to return for the check. 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 mentioned above; 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.

Run the following command to log on to mysql: mysql-uroot-ppassword (-u specifies the user name and-p specifies the password)

(-- ***-If you have been hurt, you will never forget it for the rest of your life. People who once left thought they could not leave them all their lives, but later they found that they did not. they could not survive if they left. You have never been able to realize the dream you once said, but you have found your favorite dream in your efforts. -***-) BitsCN.com