wsl2安装启动mysql

Created2025-09-10Updated2025-11-26

wsl2安装启动mysql

启动

1
sudo /etc/init.d/mysql start

配置文件

1
sudo cat /etc/mysql/debian.cnf

用户名密码就在这

1
2
3
[client]
host     = localhost

复制到用户名文件夹可以免输入用户名密码

1
sudo cp /etc/mysql/debian.cnf .my.cnf

要改变文件的所有者为用户

1
sudo chown cgz .my.cnf

遇到报错

1
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

问题就是没启动

运行上面的启动命令就行

1
root 的密码: 123456
1
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
1
CREATE USER 'mufeng'@'%' IDENTIFIED BY '123456';