MySQL Green Edition installation

Many of the online tutorials are older, completely follow the installation has not been successful, and now will be the first steps to configure their success as follows:

One, download MySQL

On the official website www.mysql.com to download, according to their own computer system to download the corresponding version, I downloaded this http://dev.mysql.com/downloads/utilities/, I downloaded the green version of the

Two, configuration file

After extracting the downloaded file, copy the My-default file in the file directory and rename it to my,

The next step is to revise the contents of the My.ini.

Copy the following code into My.ini, or compare the default code inside the My.ini to add the red part yourself.

# for advice The change settings see# http://dev.mysql.com/doc/refman/5.6/en/ server-configuration-defaults.html# * * * does not EDIT the this FILE.  It's a template which'll be copied to the# * * * default location during install, and would be replaced if you# * * * Upgrade To a newer version of MySQL. [mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128m# Remove Leading # to turn on a V  ery important data Integrity option:logging# changes to the binary log between backups.# log_bin# These is commonly set, Remove the # and set as required.# Basedir = .....Basedir =c:\program\mysql-5.6.25-winx64# DataDir = ...DataDir =c:\program\mysql-5.6.25-winx64\data# port = ... # server_id = ... # Remove leading # To set options mainly useful for reporting servers.# the server defaul TS is faster for transactions and fast selects.# Adjust sizes as needed, experiment to find the optimal values.# join_buf Fer_size = 128m# Sort_buffer_size = 2m# read_rnd_buffer_size = 2M sql_mode=no_engine_substitution,strict_trans_tables#服务端的编码方式character-set-server=utf8[client] #客户端编码方式, it is best to keep the server consistent loose-default-character-set = utf8[ Winmysqladmin] Server = "C:\program\mysql-5.6.25-winx64\bin\mysqld.exe"

Note Change the file path of the Red section to the file path of the mysql that you extracted.

Third, install the MySQL service

Start-run--cmd, right-click the Administrator Login command-line window and switch to the corresponding Bin folder with CD C:\program\mysql-5.6.25-winx64\bin. Execute mysqld-install to prompt the service to install successfully! Run Services.msc, there will be a MySQL service now, start it up.

If there are other situations where the service does not start, you will need to verify that the My.ini and MySQL installation packages are correct, and that you can proceed to the next step until there is no problem.

Four, log in to MySQL

The default user name for MySQL is root and the password is empty.

Start-run--cmd, right-click the Administrator Login command-line window and switch to the corresponding Bin folder with CD C:\program\mysql-5.6.25-winx64\bin.

Execute "mysql-u root-p", prompt to enter the password, because the first run, the password is empty can be directly enter.

Appears as shown in the Welcome page, which means login to MySQL successfully.

Five, change password

Enter exit to exit the login.

Execute mysqladmin-uroot-p Password < new password >, replace < new password > with your custom password, then press ENTER. At this point will be prompted to enter a password, in fact, refers to the original password, the original password because it is empty, so here again enter to complete the setup.

Six, other operations

By this, the green version of MySQL installation is complete, and other MySQL operations, such as restore, backup, view and so on other operations can see MySQL other relevant information.

MySQL Green Edition installation