mysql5.6 installation under Windows

MySQL Installation:

1> extracting. zip files

2> Edit System environment variable path, add; E:\Program Files\mysql56\bin

3> copy My-default.ini to My.ini,

Modify My.ini:

Basedir=e:\program files\mysql56

Datadir=e:\mysqldata

Remember, if DataDir is not the default directory, you need to copy E:\Program files\mysql56\data files into the new directory.

4> installing using the cmd command

Run--cmd--go to the DOS page,

E:

CD E:\Program Files\mysql56\bin

Mysqld-install

net start MySQL

Mysql-uroot-p

MySQL Management:

Start and stop

1>net start MySQL

2>net stop MySQL

To modify a character set:

Open My.ini

[Client]

Default-character-set=utf8

[Mysqld]

Character_set_server=utf8

init_connect= ' SET NAMES UTF8 '

This article is from the "Stone" blog, please be sure to keep this source http://dodowolf.blog.51cto.com/793581/1745037

mysql5.6 installation under Windows