Virtual machine under the Mac system VMware Fusion Win10 How to connect MySQL 5.7 via Navcat

Recently has been tossing Mac system, the original Mac use is not very familiar with, so there are a lot of problems during the installation process. For the convenience of later, of course, in order to make the same as I little white trampled some pits,

So just record these questions.

First, let's talk about VMware Fusion, the virtual machine software. I downloaded the official latest version of 8.5.7. Then start the installation, and the installation is relatively easy. The most troublesome thing is how to install the WIN10 system? At first I took a step-by-step approach to download the Win10 ISO file via the Mac's own browser Safari. The speed of the result is too much to be broken, very slow. Later I tried to take the ISO through Baidu offline download the way to download to my Baidu network disk, and then download the Baidu Network disk Mac version of the client, through the client download ISO, the speed is not stable, when fast slow. 3 days time finally download down, can not wait to install, the result has been a blue screen, has been restarted, unable to install properly, I suspect that the ISO file through the Baidu network disk download when there may be file corruption situation. In order to verify this idea, later on-line search, the original Mac system can be installed through boot Camp assiant dual system installation, I installed in this way, the problem arises and under fusion. So I can be sure when the ISO file has a problem.

In order to download the intact ISO file, I can only use my ThinkPad to download, and then copy the ISO file to my mobile hard drive. Then you start plugging the mobile drive into your Mac for installation. This time is more smooth, there is no blue screen restart problem. The system was finally installed, and finally it was making progress, and then I started installing tools under WIN10: Visual Studio 2013,tortoise git,navicat Premuim. Originally wanted to install MySQL under WIN10, consider the problem of virtual machine storage space, decided to install MySQL directly under the Mac, Nightmare began again.

Install MySQL itself is not complicated, is to download DMG files on the official website, and then double-click, then follow the prompts to install. But in order to be able to reset the password of the root of MySQL, change to a familiar password instead of a temporary password. So start resetting the password journey. Practice to search for related articles on Baidu. The approximate steps are as follows:

1. Open the preferences in the bottom dock, find MySQL, turn off the MySQL service;

2. Go to the Mysql/bin folder, get administrator privileges, and disable the authentication function of MySQL. In terminal input:

cd/usr/local/mysql/bin/

sudo su

./mysqld_safe--skip-grant-tables &

at this point you will see that the MySQL service in the preferences is turned on.

3. set a new password, in the terminal input (or just under the Mysql/bin folder):

./mysql

FLUSH privileges;

SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' your new password corresponds to the string ');

After the above steps are all done, restart MySQL, you can normally log in through the modified password. But I want to connect to MySQL in the virtual machine via navicat, I try to configure the MySQL connection information, then click "Test Connection" button, pop "ERROR 1130:host 192.168.3.100 is not allowed to Connect to this MySQL server "prompt. This query is followed by the fact that MySQL is not authorized for other client connection permissions. It was later set by the authorization law:

If you want to allow users to connect to the MySQL server from a host myuser IP 192.168.1.3 and use MyPassword as the password
GRANT all privileges on * * to ' myuser ' @ ' 192.168.0.1 ' identified by ' MyPassword ' with GRANT OPTION;

The above is the general solution, yes, there is a more troublesome is the fusion of win10 best to adjust the network connection to non-shared way, I changed to Wi-Fi, so WIN10 IP and Mac host IP on the same network segment, the connection to MySQL is no problem, Otherwise it would be troublesome to connect successfully through bridge or NAT forwarding.

Virtual machine under the Mac system VMware Fusion Win10 How to connect MySQL 5.7 via Navcat