在windows下远程调用、连接（navicat）wsl2中 mysql 8.* 的详细步骤

左阁

已于 2022-01-20 09:26:06 修改

阅读量3.5k

点赞数 15

分类专栏： wsl2 windows 远程调用文章标签： mysql windows 10 数据库开发

于 2022-01-19 16:45:38 首次发布

本文链接：https://blog.csdn.net/weixin_42580217/article/details/122583888

版权

wsl2 同时被 3 个专栏收录

1 篇文章 0 订阅

订阅专栏

windows

1 篇文章 0 订阅

订阅专栏

远程调用

1 篇文章 0 订阅

订阅专栏

以下操作都需要root权限

安装

$ apt update
$ apt install mysql-server

修改配置

vi /etc/mysql/mysql.conf.d/mysqld.cnf

修改后状态，关注

# bind-address = 127.0.0.1
# mysqlx-bind-address = 127.0.0.1

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket  = /var/run/mysqld/mysqld.sock
port            = 3306
datadir = /var/lib/mysql


# If MySQL is running as a replication slave, this should be
# changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpdir
tmpdir          = /tmp
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address           = 127.0.0.1
# mysqlx-bind-address    = 127.0.0.1
#
# * Fine Tuning
#
key_buffer_size         = 16M
max_allowed_packet      = 64M
thread_stack            = 256K

thread_cache_size       = -1

# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP

# max_connections        = 151

# table_open_cache       = 4000

登录、赋权、添加可以远程访问的用户

# 登录，wsl2安装的mysql默认没有密码
mysql -u root

# root用户没有SYSTEM_USER权限，需要先赋权
grant system_user on *.* to 'root';

# mysql 8.0 以后需要用如下命令开启远程服务，其中添加了 用户名/密码：test/123456 的用户
CREATE USER 'test'@'%' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'test'@'%'; 
ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;

重启