Win10安装绿色版MySQL 8.0

16上测试经过htmlzip文件,并解压缩到D:\MySQL目录mysqlini文件,编辑内容以下sql初始化数据文件,在命令提示换输入bash此时启动服务后就能够用root和空密码登陆了。修改root密码测试修改本机root密码ui修改网络root密码code此时本机和网络便可使用root密码登陆cdn...

该方法已经在win10 v1903企业版和MySQL v上测试过8.0.16

1. 下载MySQL zip文件并解压到D:\MySQL目录mysql

https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.16-winx64.zip

2. 在 D:\MySQL 中新建一个 my.ini 文件并编辑以下 sql

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
port = 3306  
[mysql]
default-character-set = utf8
[mysqld]
port = 3306  
basedir = D:\MySQL
datadir = D:\MySQL\data
character_set_server = utf8
max_connections = 60
# 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 = .....
# datadir = .....
# port = .....
# 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 
default_authentication_plugin = mysql_native_password

3.初始化数据文件绿色版mysql不能登陆装饰花纹笔刷下载2档案图像处理系统Ps音乐盛会宣传海报素材,在命令提示符下输入bash

电脑版微信能登陆吗_mysql数据库绿色_绿色版mysql不能登陆

mysqld --initialize-insecure

此时启动服务后绿色版mysql不能登陆,就可以用root和空密码登录了。网络

4.修改root密码测试

修改本地root密码ui

mysqld --initialize-insecure

修改网络root密码代码

mysql数据库绿色_电脑版微信能登陆吗_绿色版mysql不能登陆

此时本机和网络可以使用root密码登录cdn

5.支持

新建start.bat并输入

@echo off
echo Starting MySQL Server...
RunHiddenConsole D:/MySQL/bin/mysqld.exe
exit

新建一个stop.bat并输入

@echo off
echo Stopping MySQL Server...
taskkill /F /IM mysqld.exe > nul
exit

相关文章

发表评论