mysql 8.0 ga_mysql 8.0 GA发布了

把2楼文件释放，文件夹改为mysql8

在mysql8目录下放一个如下内容的my.ini

[mysql]

# 设置mysql客户端默认字符集

default-character-set=utf8

[mysqld]

#设置3306端口

port = 3306

# 设置mysql的安装目录

basedir=D:\\mysql8

# 设置mysql数据库的数据的存放目录

datadir=D:\\mysql8\\data

skip-grant-tables

# 允许最大连接数

max_connections=200

# 服务端使用的字符集默认为8比特编码的latin1字符集

character-set-server=utf8

# 创建新表时将使用的默认存储引擎

default-storage-engine=INNODB

# skip-networking

skip-name-resolve

skip-external-locking

enable-named-pipe        #这一行参数

用管理员用户开一个cmd窗口

C:\Windows\system32>d:

D:\>cd mysql8\bin

D:\mysql8\bin>mysqld --initialize-insecure

D:\mysql8\bin>mysqld --console

2018-04-20T08:46:47.363681Z 0 [System] [MY-010116] [Server] D:\mysql8\bin\mysqld.exe (mysqld 8.0.11) starting as process

3624

2018-04-20T08:46:49.875281Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2018-04-20T08:46:49.890881Z 0 [System] [MY-010931] [Server] D:\mysql8\bin\mysqld.exe: ready for connections. Version: '8

.0.11'  socket: ''  port: 0  MySQL Community Server - GPL.

2018-04-20T08:46:50.000081Z 0 [Warning] [MY-011311] [Server] Plugin mysqlx reported: 'All I/O interfaces are disabled, X

Protocol won't be accessible'

2018-04-20T08:48:00.201081Z 0 [System] [MY-013105] [Server] D:\mysql8\bin\mysqld.exe: Normal shutdown.

另开一个控制台窗口

D:\>cd mysql8\bin

D:\mysql8\bin>mysql --pipe

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 7

Server version: 8.0.11 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

关闭服务，在第一个窗口

^C

D:\mysql8\bin>2018-04-20T08:48:03.227481Z 0 [Warning] [MY-010909] [Server] D:\mysql8\bin\mysqld.exe: Forcing close of th

read 7  user: 'ODBC'.

2018-04-20T08:48:04.210281Z 0 [System] [MY-010910] [Server] D:\mysql8\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11)

MySQL Community Server - GPL.