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

Source: Internet
Author: User
Tags change settings mysql client win32 dedicated server

1. Database download
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.67[Mysqld]89# 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%.One innodb_buffer_pool_size =128M1213# Remove Leading # to turn on a very important data integrity option:logging14# Changes to the binary log between backups.15# Log_bin16These is commonly set,Remove the # and set as required.18#mysql根目录Basedir = "C:\Program files\mysql-5.6.22-win32"20#数据文件存放目录DataDir = "C:\Program files\mysql-5.6.22-win32\data"# port =..... Port, Default 3306# server_id =..... Unique identification of the service instance242526# Remove Leading # To set options mainly useful for reporting servers.27# The server defaults is faster for transactions and fast selects.# Adjust sizes as needed,Experiment to find the optimal values.# join_buffer_size =128M# sort_buffer_size =2M# read_rnd_buffer_size =2M32Sql_mode=no_engine_substitution,strict_trans_tables 34  #服务端的编码方式 35 character-set-server=utf836 [ client] #客户端编码方式, it is best to save the server consistent 38 Loose-default-character-set = Utf839 40 [winmysqladmin] 41 Server = "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.

1. Enter the DOS window

2. Execute the command to install the MySQL service name: D:\AppServ\MySQL\bin\mysqld-nt-install mysql--defaults-file= "D:\Appserv\MySQL\my.ini"

The service successfully installed appears. Indicates that the installation was successful.

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 feeling very useful, a variety of operation at a glance, There is also a sqlyog also good.

  

6. Open Remote Login

After MySQL installation is completed by default only native (that is localhost) login, we need to open remote login for easy use. Open method There are many, Baidu a lot, I said the test through the method

X:\>mysql-U Root-p password//Login system MySQL>Use MySQL;//Switch database MySQL>UpdateUserSet host=‘%‘whereUser=‘Root‘;The above sentence sometimes comes with a wrong error1062 (" %-root ' for key  ' 

Test the remote connection again, it's ready.

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.