MySQL Green Edition installation

1. Download Mysql5.6.10ga decompression version, this is not much to say also no, under or under the good after not know how to decompress the next article is not much to see.

2. After the decompression into the root directory is such a situation (I use the MYSQL5.6.10GA version, different versions of the file will be a little different)

3. Configure the environment variables, according to my decompression to the directory, the path is "D:\work\mysql-5.6.10-win32\bin" (in fact, the root directory of the bin path is configured into the environment variable), here also do not elaborate, will not find their own information

4. Rename the My-default.ini file to My.ini, and add a word "Character-set-server=utf8" inside it to allow the internal MySQL to be stored in the uft-8 character set. Instead of the default latin1 (PS: "Default-character-set=utf8" can not be used here, the reason is that the MySQL 5.5+ version under the My.ini [MYSQLD] Item can no longer write default-character-set= UTF8). Of course, you can also set a lot of other parameters, not listed here. Anyway, the parameters are not set according to the system default, which is why if you do not set the UTF8 character set here, the system will take the default latin1 reason.

5. In the CMD Command Line window, the MySQL here refers to the service name, you can take it yourself, but after the start of the service, the name to be with here has been, the most important thing is to take the following "--defaults-file=" This parameter, otherwise, the system will use the default parameters

If you see the following sentence, congratulations, the service has been successfully installed

6. Enter the following command

If you see these two lines, then congratulations, have successfully installed

But if you see the

It is regrettable that your My.ini configuration file has errors, here is a reminder, that is, do not put the online my.ini files randomly find a copy all over, because the different MySQL version, a lot of configuration information is not the same, as just said mysql5.0 and 5.5 + Small details, so many cases, if you are not MySQL master, suggest or use the default settings better

7. Next, you can enter the command to enter MySQL (note: I am here because it is afterwards, so has changed the root account password, if you are the first time to enter, directly enter "Mysql-u root" on the line, how to change the password and some other small commands can refer to this blog post, There's a part of it. How to install the compressed version of MySQL)

At this point, the approximate end

Ps:

In fact, I see a lot of online explain how to modify the MySQL default character set for UTF8 article, they all said to modify the properties of the My.ini file, in fact, this is not wrong, but in many cases, will encounter even if modified, there is no effect of the problem, it is necessary to remove the MySQL service

I'll just go back to the way I taught you, just install it.

MySQL Green Edition installation