MySQL installation configuration uses

Compressed version

Download the Oracle website mysql compression pack

I use 64 bits.

1, extract to the specified directory disk such as: C:\mysql\mysql-5.7.10-winx64

2, new My.ini under Configuration directory

The contents are as follows:

[MySQL]

# Set the MySQL client default character set

Default-character-set=utf8

[Mysqld]

#设置3306端口

Port = 3306

# set up the MySQL installation directory

Basedir=c:\mysql\mysql-5.7.10-winx64

# Set up a storage directory for MySQL database data

Datadir=c:\mysql\mysql-5.7.10-winx64\data

Tmpdir=c:\mysql\mysql-5.7.10-winx64\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

3. Start MySQL

Configure environment variables Path C:\mysql\mysql-5.7.10-winx64\bin;

Cmd.exe Run as Administrator

Execute command: CD C:\mysql\mysql-5.7.10-winx64\bin

Mysqld Install

net start MySQL

Mysql-u root-p

If the error can be performed for several reasons,

The following are the first steps to start MySQL before building a table in the library do the Operation

Turn off the service Windows Task Manager process Mysqld.exe whether it exists or not, delete

Uninitialized then performs a shutdown of the service net stop MySQL and then initializes the Mysqld initialize

It's still not working. net stop MySQL Delete mysqld-remove re-engage

Re-Mysqld-install

Login failure password Forget to wait for the fundamental login not to directly recharge the password set empty in to re-engage

Turn off service net stop MySQL and then execute mysqld--skip-grant-tables--user=root

Login Mysql-uroot set root password to root(set your own remembered password)

Mysql>set PASSWORD for ' root ' @ ' localhost ' = PASSWORD ('root');

Forgot password

mysqladmin-u root password Oldpass "root" is done.

MySQL installation configuration uses