Mysql下载地址:https://dev.mysql.com/downloads/mysql/
根据电脑位数下载相应的zip文件包(还有.msi的文件,那个安装过程略)
配置好相应变量后,安装mysql:mysqld -install 并初始化:mysqld --initialize
启动Mysql:
在mysql根目录下的my.ini下[mysqld]下添加一句代码 “skip-grant-tables”如下:
[client]
port=3306
default-character-set=utf8
[mysqld]
# 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.
character-set-server = utf8
port = 3306
bind-address = 127.0.0.1
basedir=D:\mysql-5.7.27-winx64
# 设置为MYSQL的数据目录
datadir=D:\mysql-5.7.27-winx64\data
#开启查询缓存
explicit_defaults_for_timestamp=true
skip-grant-tables
保存后,再重新启动MySQL。
登入mysql:在输入密码一栏,直接回车跳过,便会自动跳过输密码直接进入。
之后执行以下语句(不要忘了加分号!)
若出现下面的错误
解决办法:先执行 flush privileges; 再执行一次上次指令即可,如下:
然后退出,将my.ini中的 skip-grant-tables 删除掉,保存,然后重启Mysql,再次登录便需要密码。