Shulou(Shulou.com)05/31 Report--

How do I connect to the local wsl database using navicat? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

1. Modify the configuration file of MySql

Sudo vim / etc/mysql/mysql.conf.d/mysqld.cnf

You will find bind-address = 127.0.0.1 and comment out → # bind-address = 127.0.0.11

Change port to 3307 (avoid conflicts with MySql installed on win10 systems)

two。 Add character-set-server=utf8

2. Restart mysql

Service mysql restart

3. Enable root remote access

# after logging in to mysql, operate in the database: (of which 12346 is changed to your database root password)

Mysql > GRANT ALL PRIVILEGES ON *. * TO 'root'@'%'IDENTIFIED BY' 123456 'WITH GRANT OPTION

Mysql > flush privileges

4. Connection test

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.