MySQL Green edition installation (Mysql-5.6.22-win32.zip)

Because the work needs to start studying MySQL recently (it seems that learning is forced out), I do not study MySQL, can say a small white. Let's start with the installation, although there are many things on the internet that need to be written down.

1. Database download

MySQL official website: http://www.mysql.com/, database: http://www.mysql.com/downloads/. From the official website can find two kinds of packages, one is EXE installer, the other is a zip compression package. I like the refreshing way, so the download is the ZIP compression package. The newest 5.6.22 about 350M, download also need Oracle account, oneself register a good.

2. Database Installation

Extract the downloaded file Mysql-5.6.22-win32.zip (with the x86 and x64 two versions) to any directory, to prevent the unknown problem, preferably in non-system disk non-Chinese directory, my location C:\Program files\ Mysql-5.6.22-win32. Open a folder to copy a configuration file My-default.ini to My.ini.

Open the My.ini file and modify the configuration as follows

1 # for advice the change settings2# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html3 # * * * Don't EDIT this FILE. It ' s a template which 'll be copied to the4# * * * default location during install,and would be replaced if you5 # * * * * Upgrade to a newer version of MySQL.6 7 [mysqld]8 9 # Remove Leading # and set to the amount of RAM for the most important dataTen# Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%. OneInnodb_buffer_pool_size =128M A  - # Remove Leading # to turn on a very important data integrity Option:logging - # Changes to the binary log between backups. the # Log_bin -  -# These is commonly set,Remove the # and set as required. - #mysql根目录 +Basedir = "C:\Program files\mysql-5.6.22-win32" - #数据文件存放目录 +DataDir = "C:\Program files\mysql-5.6.22-win32\data" A# port = ..... Port, default 3306 at# server_id = ..... Unique identification of the service instance -  -  - # Remove Leading # To set options mainly useful for reporting servers. - # The server defaults is faster for transactions and fast selects. -# Adjust sizes as needed,experiment to find the optimal values. in# join_buffer_size =128M -# sort_buffer_size =2M to# read_rnd_buffer_size =2M +  -Sql_mode=no_engine_substitution,Strict_trans_tables the #服务端的编码方式 *Character-set-server=UTF8 $ [Client]Panax Notoginseng #客户端编码方式, it's best to keep it consistent with the server -Loose-default-character-set =UTF8 the  + [Winmysqladmin]   AServer = "C:\Program Files\mysql-5.6.22-win32\bin\mysqld.exe"

The above set up in order to ensure the normal operation of the service, according to their own needs to adjust parameters, modified to restart the service.

3. Registering MySQL Service

Start-run--cmd, and then CD to the MySQL installation directory under the bin, my directory is "C:\Program Files\mysql-5.6.22-win32\bin", and then execute Mysqld-install, prompt service installation success! Run Services.msc A look, there really is a service called MySQL, start it. Sometimes the start fails and the parameters can be adjusted as appropriate.

Here MySQL installation even if completed, in fact, it is quite simple, but if there is no operation, the whole process is estimated to take a lot of time, but also the process of growth must.

4. Login and maintain MySQL

Installation is successful, also started, how to login ah? What is a user name and password?

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

How do I log in? Or start-run--CMD,CD to the bin directory, and then execute "mysql-u root-p", prompting for a password, because the first run, the password is empty can be directly entered.

Let's set a password for the database. Enter exit to exit the login. Then run Run C:\Program files\mysql-5.6.22-win32\bin\mysqladmin-uroot-p password < new password >, < new password > Replace 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. Then log in to MySQL with the above method and the new password to work properly.

Run "show variables like '%version% '" To view database related information

　　

This completes the installation of the entire database.

Although the MySQL client can do all about the database operation, but the Black command line interface is still a lot of people to be deterred, learning curve straight up, here to recommend a tool navicate for MySQL, personal very useful, a variety of operation at a glance.

　　

MySQL Green edition installation (Mysql-5.6.22-win32.zip)