mysql zip版本windows10安装

 

文章目录

• 一、下载mysql
• 二、配置mysql
• 三、测试安装是否成功

---

一、下载mysql zip版本

官网下载地址：MySQL :: Download MySQL Community Server

二、配置mysql

1.解压mysql-8.0.21-winx64.zip

2.进入解压文件夹，创建my.ini空白文件

3.编辑my.ini文件，设置basedir和datadir,将下面代码拷贝到my.ini,basedir设置为实际的解压包的绝对路径，datadir可设置为解压目录下新建的data文件夹

[mysqld]
default_authentication_plugin=mysql_native_password
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
 
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
 
# These are commonly set, remove the # and set as required.
basedir=C:\\develop\\mysql8\\mysql-8.0.21-winx64
datadir=C:\\develop\\mysql8\\mysql-8.0.21-winx64\\data
port = 3306
# server_id = .....
 
 
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 
 
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
 
character-set-server = utf8mb4
 
performance_schema_max_table_instances = 600
table_definition_cache = 400
table_open_cache = 256
 
[mysql]
default-character-set = utf8mb4
 
[client]
default-character-set = utf8mb4

注意：basedir 中路径为 两个反斜杠“\\”,或者一个正斜杠“/”

以管理员方式打开cmd，进入解压的bin目录下面，输入：

mysqld --initialize-insecure

输入之后，会生成data文件夹

安装mysql 服务,在bin目录下，以管理员方式输入：

 

mysqld install mysql

三、登陆并修改密码，测试安装是否成功

启动数据库：

net start mysql

登陆mysql 初始安装密码默认为空：

mysql -u root -p

提示输入密码时候，直接enter，进入mysql

修改登陆密码为123456，实际生产时需要设置为复杂的密码：

alter user root@`localhost` identified by '123456';

修改完之后，需要刷新权限使修改生效；

 flush privileges;

重新登陆测试：输入exit ，然后输入mysql -u root -p,然后输入密码“123456”，回车，测试登陆成功！