Installation of Mysql5.6 under Windows

The contents are as follows

[Mysqld]

Loose-default-character-set = UTF8

Basedir = e:/mysql-5.6.11-winx64

DataDir = E:/mysql-5.6.11-winx64/data

Port = 3306

Sql_mode=no_engine_substitution,strict_trans_tables

Character_set_server = UTF8

[Client]

Loose-default-character-set = UTF8

3. Open a command prompt, enter the%mysql_home%/bin directory, and execute the command: Mysqld-install install MYSQL to the Windows service. After successful execution, you will be prompted: D:\mysql-5.6.30-winx64\bin>service successfullyinstalled.

If you want to uninstall the Service execution command: Mysqld-remove.

Then execute at the command prompt: net start MySQL can start MySQL, stop service input command: net stop MySQL. If you want to set MySQL to start automatically, you can set it up in the Start menu, run, enter Service.msc to open service management.

4. Change the root user password

Run D:\mysql-5.6.30-winx64\bin/mysql.exe

D:>mysql–uroot

Mysql>show databases;

Mysql>use MySQL;

Mysql>update user SET Password=password ("123456") WHERE user= ' root ';

Mysql>flush privileges; "Attention must not forget this sentence, otherwise the password change cannot take effect"

Mysql>quit

5 Installing the MySQL client

Unzip navicat Premium rar file, point file-New connection-mysql

This article is from the "one dish can no longer dish of the Little rookie" blog, please be sure to keep this source http://liliming.blog.51cto.com/10925034/1795791

Installation of Mysql5.6 under Windows