安装mysql8

Windows 系统 MySQL 安装与配置全攻略：从新手到进阶的实战指南：https://blog.csdn.net/weixin_42593797/article/details/147922148

解决mysql常见错误，安装mysql提示Install/Remove of the service Denied!/显示无法启动/服务名无效:https://blog.csdn.net/qq_62975017/article/details/132076949

mysql
K8s!Admin2026#

1、E:\mysql_2\mysql-8.0.27-winx64\bin

2、mysqld --initialize-insecure

3、mysqld --install mysql80

4、sc delete mysql80

5、net start mysql80

6、mysql -u root # 免密登录
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; # 设置新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; # 设置新密码

7、[mysqld]
port=3306
socket=D:\MySQL\mysql-8.0.33-winx64\data\mysql.sock
log-error=D:\MySQL\mysql-8.0.33-winx64\data\error.log
slow_query_log=1
slow_query_log_file=D:\MySQL\mysql-8.0.33-winx64\data\slow.log
long_query_time=2
innodb_buffer_pool_size=2G # 建议为物理内存的50%-70%
max_connections=1000
SET GLOBAL innodb_buffer_pool_size = 4G; -- 调整缓冲池大小
FLUSH PRIVILEGES; -- 立即生效

8、检查端口占用：netstat -ano | findstr :3306

9、重启服务：net stop mysql80 && net start mysql80

10、

win11 安装 mysql 8：https://cloud.tencent.com/developer/article/2611969，https://pan.quark.cn/s/6ba3b2bb3196