Installation configuration for MySQL

MySQL Green edition installation steps and FAQs:

1, download installation package, 32-bit PC and 64-bit different

2, New My.ini,

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory
Basedir=e:\mysql\mysql-5.6.24-win32
# Set up a storage directory for MySQL database data
Datadir=e:\mysql\mysql-5.6.24-win32\data
# Maximum number of connections allowed
max_connections=200
# The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb
[Winmysqladmin]
Server=e:\mysql\mysql-5.6.24-win32\bin/mysqld.exe

3, configure the path path to the bin

4,
CMD in execute command: mysqld--install MySQL--defaults-file= "F:\mysql\mysql-5.6.25-winx64\my.ini"
Add Registry

net start MySQL prompt system could not find the specified file.

5,cmd--regeditsystem the third one to find MySQL
Modify the image parameter: "F:\mysql\mysql-5.6.25-winx64\bin\mysqld"--defaults-file= "F:\mysql\mysql-5.6.25-winx64\my.ini" MySQL

6, this time successfully started

7, Change Password:
Mysql>use MySQL;
Mysql>update user SET Password=password (' Enter new password ') WHERE user= ' root ';
Mysql>flush privileges;

8, set allow other computers to access, all, by password authentication.

GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;
Where: MyUser user name, MyPassword is the login password.

Installation configuration for MySQL