Win10--MySQL8.0.29 免安装版本的配置教程及问题解决

MYSQL_HOME = H:\Tools\mysql-8.0.29-winx64
在path中添加%MYSQL_HOME%\bin


cd C:\Tools\mysql-8.0.29-winx64\bin
以管理员的身份打开cmd窗口，输入命令: mysqld --defaults-file=H:\Tools\mysql-8.0.29-winx64\my.ini --initialize --console


 root@localhost: wg*zoiiW-75C

（1）安装mysql服务
mysqld --install mysql
（2）启动mysql服务
net start mysql   

mysql -u root wg*zoiiW-75C


alter user 'root'@'localhost' identified by '123456';
flush privileges:


Win10--MySQL8.0.29 免安装版本的配置教程及问题解决
https://blog.csdn.net/penriver/article/details/124644146https://blog.csdn.net/weixin_43579015/article/details/117228159?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522166839393816782388070543%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=166839393816782388070543&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~hot_rank-2-117228159-null-null.142^v63^control_1,201^v3^control_1,213^v2^t3_esquery_v1&utm_term=%E5%AE%89%E8%A3%85mysql8.0&spm=1018.2226.3001.4187


执行命令

use mysql;

select user,plugin from user where user='root';

可以看到当前用户的加密方式为caching_sha2_password

执行命令

alter user 'root'@'localhost' identified with mysql_native_password by '123456';

flush privileges;


=============my.ini=================

[mysqld]
port=3306
basedir="H:\Tools\\mysql-8.0.29-winx64"
datadir="H:\Tools\\mysql-8.0.29-winx64\\data"
max_connections=200
max_connect_errors=10
character-set-server=utf8mb4
default-storage-engine=INNODB

[mysql]
default-character-set=utf8mb4

[client]
port=3306
default-character-set=utf8mb4

 遇到vcruntime140_1.dll错误，安装【微软常用运行库合集_2019.07.20_X64】