Ubuntu installation configures MySQL and remotely manages MySQL using the VS Server Explorer UI interface

For easy installation, use the root account to log in to Ubuntu.

Step1: Type the following command to install MySQL. The process is simple. Simply enter the root account password as prompted during the installation process.

Step2: Check that MySQL is started after the installation is complete. Type the following command

Step3: If it is not started, type the following command to start MySQL. Then follow the Step2 and check again for MySQL running status.

STEP4: Open the remote access feature for MySQL. Type the following command, and then comment out the bind-address in the configuration file.

STEP5: Restart MySQL

STEP6: Open the root user's remote access permission: Change password to the password you intend to set. In this step, the MySQL setup is complete.

STEP7: Go back to the Windows system and install the MySQL for Visual stuido plugin. The website is available for download. Once installed, you can see MySQL data Provider in the DataSource vs.

STEP8: Next you can access MySQL in VS (query data, database management operations are supported)

Ubuntu installation configures MySQL and remotely manages MySQL using the VS Server Explorer UI interface