mysql 解压版 服务_MySQL服务解压版安装

1.环境变量配置

右键计算机–属性–高级系统设置–环境变量，在系统变量中找到Path编辑，在结尾处追加你的mysql的bin文件夹地址D:\Program Files\mysql-8.0.12-winx64\bin

2.创建my.ini文件[client]

# pipe=

socket=MYSQL

port=3306

[mysql]

no-beep

# default-character-set=

# SERVER SECTION

# ----------------------------------------------------------------------

#

# The following options will be read by the MySQL Server. Make sure that

# you have installed the server correctly (see above) so it reads this

# file.

#

# server_type=3

[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.

# skip-networking

# enable-named-pipe

# shared-memory

# shared-memory-base-name=MYSQL

# The Pipe the MySQL Server will use

# socket=MYSQL

# The TCP/IP Port the MySQL Server will listen on

port=3306

# Path to installation directory. All paths are usually resolved relative to this.

basedir=D:\Program Files\mysql-8.0.12-winx64

# Path to the database root

datadir=D:\Program Files\mysql-8.0.12-winx64\data

# The default character set that will be used when a new schema or table is

# created and no character set is defined

# character-set-server=

# The default storage engine that will be used when create new tables when

default-storage-engine=INNODB

# Set the SQL mode to strict

sql-mode=

3.配置MySQL服务

a) 用管理员身份打开cmd，进入mysql的bin文件夹。(注意要用管理员打开，否则权限不足)

b)执行：mysqld -install,显示：Service successfully installed. 则注册服务成功。如果要删除服务：mysqld -removec)MySQL数据库在升级到5.7版本后，和之前的版本有些不一样，没有data文件夹，MySQL数据库文件是保存在data文件夹中的，标准的修改方法是，打开cmd命令窗口，并且进入到MySQL安装目录中的bin目录，然后输入如下命令初始化数据：mysqld –initialize-insecure 。执行完上面命令后，MySQL会自建一个data文件夹，并且建好默认数据库，登录的用户名为root，密码为空。

d)安装成功后就要启动服务了，继续在cmd中输入net start mysql，停止服务net stop mysql。

如果失败查看错误日志，D:\Program Files\mysql-8.0.12-winx64\data下*.err日志

4 登陆mysql服务，修改密码

a)继续在cmd中输入:mysql -u root 回车，密码为空，继续回车，连接上mysql。

b)屏蔽权限：mysqld --skip-grant-tables.flush privileges;

c)8.0版本以上： alter user 'root'@'localhost'IDENTIFIED BY '123';注：mysql8.0以上密码策略限制必须要大小写加数字特殊符号，我没碰到，修改失败的话注意一下

8.0版本以下：set password for root@localhost =password('root');

d)FLUSH PRIVILEGES;