Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to install mysql-5.6.21-winx64.zip", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to install mysql-5.6.21-winx64.zip" this article.

Installation of mysql-5.6.21-winx64.zip

1. Install the windows service (the Windows7 user must start cmd as an administrator):

Mysqld.exe-install MySQL-- defaults-file=D:\ tools\ mysql-5.6.21-winx64\ my.ini

Note:

When mysqld.exe-install, if you don't have defaults-file, you will find my.cnf first and then my.ini by default.

2.start up

Net start MySQL

An error will be reported if there are unrecognized parameters: # MySQL5.6 profile my.ini 1067 error

You can view it from the HOSTNAME.err file at this time

3. Log in to change the password

Mysql-u root-p

Mysql > update user set password = PASSWORD ('root') where user='root'

Mysql > flush privileges

You can't see the library called "mysql" by typing enter directly with mysql, because it is not a root user.

Mysql > select current_user

+-+

| | current_user |

+-+

| | @ localhost |

+-+

1 row in set (0.00 sec)

Mysql > select user ()

+-+

| | user () |

+-+

| | ODBC@localhost |

+-+

1 row in set (0.00 sec)

4.my.ini configuration

Minimum configuration:

[mysqld]

Basedir = D:/tools/mysql-5.6.21-winx64

Datadir = D:/tools/mysql-5.6.21-winx64/data

Here is my configuration

# The MySQL server

[mysqld]

Server_id = 10

Port = 3306

Socket = mysql.sock

Basedir = D:/tools/mysql-5.6.21-winx64

Datadir = D:/tools/mysql-5.6.21-winx64/data

#

Skip-external-locking

Lower_case_table_names = 1

Default-storage-engine = InnoDB

Character-set-server = utf8

Init_connect='SET NAMES utf8'

Key_buffer_size = 8m

Max_allowed_packet = 1m

Table_open_cache= 64

Sort_buffer_size=512K

Net_buffer_length = 8K

# log_bin

Sync_binlog = 1

# innodb_support_xa = 0

Slow-query-log = TRUE

Slow-query-log-file = D:/tools/mysql-5.6.21-winx64/data/mysql-slow.log

The above is all the contents of the article "how to install mysql-5.6.21-winx64.zip". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.