该方法已经在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
mysqld --initialize-insecure
此时启动服务后绿色版mysql不能登陆,就可以用root和空密码登录了。网络
4.修改root密码测试
修改本地root密码ui
mysqld --initialize-insecure
修改网络root密码代码
此时本机和网络可以使用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
发表评论