How to connect to virtual machine MySQL using VScode in window environment

1. Virtual Machine Side

1. Find the mysql configuration file

:sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

Press the "i" key to enter the edit mode, find the following item, and change the address to "0.0.0.0"

Restart mysql service

:sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

2. Connect to MySQL

:mysql -uroot -hlocalhost -p

Enter the code and press Enter, and you will be prompted to enter the database password

3. Authorize users

>>grant all privileges on *.* to 'username'@'%' identified by 'password' with grant option;

Can be root user

4. Refresh authorization

>>flush privileges;

2. Windows

1. Open VScode and install the following 2 plug-ins

This will appear in VScode

2. Now you can connect to the MySQL database

2.1 Enter the IP address of the virtual machine

If you don't know, you can use the following command to query

:ifconfig

2.2 Enter the username and password (the user and password previously authorized on the virtual machine)

2.3 Output port number (default 3306)

2.4 You don’t need to input this item, just press Enter

At this point you can see that VScode has connected to the MySQL database on the virtual machine.

The above is a detailed explanation and integration of the method of using VScode to connect to the virtual machine MySQL in the window environment introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!