Mysql8.0至MySql8.3.x解压缩版之Windows中快速安装
1. 下载与安装
- 官网下载:https://dev.mysql.com/downloads/
- 安装文件:mysql-8.0.23-winx64.zip
- 解压到D下:如:D:\mysql-8.0.23-winx64
- 环境变量配置
- 在系统变量中新增下面配置
变量名:MYSQL_HOME
变量值:D:\mysql-8.0.23-winx64
- 在系统变量的path变量值后面新增下面代码
xxxx;%MYSQL_HOME%\bin
- 在D:\mysql-8.0.23-winx64下新建my.ini,内容如下
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[mysqld]
# 设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=E:\\MySqlServer\\mysql-8.0.23-winx64
# 设置 mysql数据库的数据的存放目录,MySQL 8+ 不需要以下配置,系统自己生成即可,否则有可能报错
# datadir=E:\\MySqlServer\\mysql-8.0.23-winx64 #8.0以下版本需要配置数据目录
# 允许最大连接数
max_connections=20
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 默认使用“mysql_native_password”插件认证解决客户端无法连接的问题
default_authentication_plugin=mysql_native_password
- 进入D:\mysql-8.0.23-winx64\bin目录下,以管理员身份打开cmd窗口,执行下面命令,产生root密码,牢记此密码
D:\mysql-8.0.23-winx64>mysqld --initialize --console
# root@localhost: 后面就是生产的root密码
...
root@localhost: CB.o+wFSV3ij
...
D:\mysql-8.0.23-winx64>
aurlv:oj7TuV
- 进入到MySQL的bin目录下,执行下面命令
mysqld --install [服务名](服务名可以不加默认为mysql)
D:\mysql-8.0.23-winx64\bin>mysqld --install
Service successfully installed.
D:\mysql-8.0.23-winx64\bin>
如果出现下面这,表示已经安装过mysql,则使用 命令sc delete mysql删除后重新安装
D:\mysql-8.0.23-winx64\bin>mysqld --install
The service already exists!
- 安装完成后,启动mysql服务
#启动服务
net start mysql
# 停止服务
net stop mysql
2. 首次登录MySQL服务及修改root密码
- 使用下面命令登录MySQL服务
C:\Users\dell>mysql -u root -p
Enter password: ******* # 首次登陆输入安装过程中产生的root用户密码,如:CB.o+wFSV3ij
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 8.0.23 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
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>
- 修改root密码,举例:如密码改为 yuan
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'yuan';
Query OK, 0 rows affected (0.61 sec)
mysql>alter user 'root'@'%' identified with mysql_native_password by 'root';
3. 设置客户端可连接远程MySQL服务器
- 用root账号登陆,切换至mysql库
mysql> use mysql;
Database changed
mysql>
- 查看host字段
# localhost 表示只能在本地访问
# % 远程任何主机可以访问root账户
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)
mysql>
- 修改host为值为”%“
update user set host='%' where user='root';
- 再次使用客户端连接成功