Unity3d Connect MySQL Database Note 1-install MySQL database

This tutorial uses the MySQL5.0 version

All the way to the next installation, to 3 options here

Select a custom

Left-click on "MySQL server", select "This feature, and all subfeatures, will is installed on the local hard drive.", i.e. "this section, and the subordinate sub-section Installed on the local hard drive

Direct Next installation Next

Know that there's this

Tick, start configuring MySQL Now

Continue to the next step, to this figure here

Choose the configuration method, "Detailed configuration (manual precise configuration)", "Standard Configuration", we select "Detailed Configuration", easy to familiarize with the configuration process.

This diagram will appear next

Select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL takes up more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) ", people choose according to their own type, generally choose" Server machine ", not too little, will not be full.

Here I choose Developer Machine (Development test class, MySQL occupies very little resources) simple test, can choose the corresponding server type according to your own needs

Choose the general purpose of MySQL database, "Multifunctional database (Universal multifunction, good)", "Transactional database only (server type, focus on transaction processing, general)", " Non-transactional Database only (non-transactional, simpler, mainly to do some monitoring, counting, the MyISAM data type support is limited to non-transactional), with their own use and choice,

Here I select "Transactional Database only" and press "Next" to continue.

Next to the InnoDB tablespace configuration, is to select a storage space for InnoDB database files, if modified, to remember the location, reload the time to choose the same place, otherwise it may cause database corruption.

We've chosen to proceed to the next step

Select your site's general MySQL traffic, number of simultaneous connections, "decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500)", " Manual Setting (manually set, lose one's own number) ",

I choose "Manual Setting (manually set, lose one number)", enter 15, the native development MySQL program, enough, press "Next" to continue.

whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on your own machine, I am here to enable, put the front tick, Port number:3306, on this page, you can also select "Enable Standard mode" (enabling Strict Mode) so that MySQL does not allow for small grammatical errors. If you're still a novice, I recommend canceling the standard mode to reduce the hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. There is also a firewall setting "ADD Firewall exception ..." needs to be selected, add the listening port of the MySQL service to Windows Firewall exception, avoid firewall blocking. "I am here because my default Windows Firewall has been turned off, so do not tick, if your firewall is on, please tick this add firewall exception" Press "Next" to continue.

This is more important, is to set the MySQL default database language encoding, the first is the Latin code, the second is a multi-byte universal UTF8 encoding, is not our universal encoding, select a third here, and then Select or fill in the character Set "GBK" , of course, can also use "gb2312", the difference is that the GBK font capacity, including all the characters of gb2312, and the addition of traditional characters, and other chaotic words-when using MySQL, run a "SET NAMES GBK" before executing the data manipulation command. (Run once on the line, GBK can be replaced with other values, depending on the settings here), you can normally use Chinese characters (or other text), otherwise it will not be normal display of Chinese characters. Press "Next" to continue.

Choose whether to install MySQL as a Windows service, you can also specify the service name, or whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin without indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue.

This step asks if you want to modify the default root user (super Admin) password (default is empty), "New root password" If you want to modify, fill in the new password here (if it is a reload, and have already set a password here, change the password here may be error, please leave blank, and will "Modify Security Settings "in front of the hook removed, the installation configuration after the completion of a separate password)," Confirm (again lost) "filled again, to prevent the wrong. "Enable root access from remotemachines (whether to allow root users to log on to other machines, if it is safe, do not tick, if it is convenient, tick it)". Finally "Create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, unable to manipulate data, including queries)", generally do not check, set up, press "Next" to continue.

Appears to indicate that the installation was successful

Note: After setting up, press "Finish" to end the installation and configuration of MySQL--here is a more common error, is not "StartService", generally appear in the previous server installed MySQL, the solution, first ensure that the previous installation of MySQL The server has been completely uninstalled; if not, check whether the previous password has been modified, according to the above, if not, the MySQL installation directory of the Data folder backup, and then delete, after the installation is completed, the installation of the generated Data folder deleted, Back up the Data folder and restart the MySQL service, in which case you might need to check the database and fix
Repeat to prevent data errors

Let's fight. Navicatformysql Manager Test the connection

Enter the root password that you just configured, click Connect Test

This diagram shows that MySQL is installed and configured successfully!