Shulou(Shulou.com)06/02 Report--

Installing mysql under windows can be troublesome, so install MySQL into the virtual machine. The main purpose of this article is to let win10, the host, access the mysql in the virtual machine.

Environment: windows10 (host) ubuntu18 (virtual system)

Step 1: install mysql (version 5.7) in the virtual machine:

Sudo apt-get install mysql-server

Step 2: modify the mysql configuration:

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

Note # bind-address=127.0.0.1

Step 3:

Log in to the database to modify permissions:

Sudo mysql-u root-p

Grant all privileges on. To root@ "" identified by "pwd" with grant option

Flush privileges

Service mysql restart

Step 4:

Step 5: win10 client navicat connects to the virtual machine database

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.