下载
安装
1.下载完成后解压,然后在根目录创建my.ini配置文件
[client]
# 设置mysql客户端默认端口
port=3306
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=D:\\mysql-8.0.20-winx64
# 设置 mysql数据库的数据的存放目录,MySQL 8+ 不需要以下配置,系统自己生成即可,否则有可能报错
# datadir=D:\\mysql-8.0.20-winx64\\sqldata
# 允许最大连接数
max_connections=20
# 允许最大连接失败的次数
max_connect_errors=10
# 服务端默认字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
注意:安装目录更改为实际路径
2.初始化数据库(cmd命令行操作)
D:\>cd mysql-8.0.20-winx64\bin
D:\mysql-8.0.20-winx64\bin>mysqld --initialize --console
2020-06-25T07:26:11.484928Z 0 [System] [MY-013169] [Server] D:\mysql-8.0.20-winx64\bin\mysqld.exe (mysqld 8.0.20) initializing of server in progress as process 11604
2020-06-25T07:26:11.502016Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-06-25T07:26:12.196054Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-06-25T07:26:13.610847Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: y.#e8Vqk&QAW
记住这里的root初始化密码,后面登录或者修改会用到的。
初始化时遇到两个问题:
1)由于找不到VCRUNTIME140_1.dll,无法继续执行代码
缺少微软运行的库,可在微软官网https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads 找到对应版本下载安装即可
2)–initialize specified but the data directory has files in it
默认data目录为根目录下的data/,这里提示data文件夹不为空,虽然我也不清楚这个文件夹为啥不是空的,但是将此文件夹清空再重新运行初始化命令即可解决此问题。
3.安装并启动mysql服务
D:\mysql-8.0.20-winx64\bin>mysqld --install
Service successfully installed.
D:\mysql-8.0.20-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
注意:以上操作需要使用管理员运行cmd
4.登录mysql
D:\mysql-8.0.20-winx64\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.20
Copyright (c) 2000, 2020, 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>
这里是初始密码,若要修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your new password';
5.配置环境变量
将mysql/bin加入环境变量,这样就不用了每次都到这个目录下进行登录了
mysql workbench
这是mysql官方提供的图形化管理工具,方便数据库操作和管理
mysql workbench官方下载