How to Use Navcat to connect to Mysql 5.7 in Windows 10 of VMware Fusion on a Mac system,

How to Use Navcat to connect to Mysql 5.7 in Windows 10 of VMware Fusion on a Mac system,

Recently I have been tossing over the Mac system. I was not very familiar with Mac, so many problems occurred during the installation process. In order to facilitate future access, and of course to make it easier for me,

So record these issues.

Let's talk about the Virtual Machine Software VMware Fusion. I downloaded the latest official version 8.5.7. Then start the installation, which is easier to install. The most troublesome thing is how to install the WIn10 system? At first, I took a step-by-step approach to download Win10 ISO files through Safari, the browser that comes with Mac. The result speed is too slow to crash. Later, I tried to download ISO to my Baidu network disk in the offline download mode, and then downloaded the Baidu Network Disk Mac client and the ISO from the client, the speed is also unstable, fast and slow. After three days of download, you can't wait to install it. As a result, the blue screen is displayed, and the installation cannot be properly restarted, I suspect that the ISO file may be damaged when downloaded through Baidu online storage. In order to verify this idea, I came to the Internet for a search. In the old Mac system, I could use Boot Camp Assiant for dual system installation. I installed it in this way, and the problem was the same as that in Fusion. So I'm sure there is a problem with the ISO file.

To download intact ISO files, I can only use my ThinkPad to download them, and then copy the ISO files to my mobile hard disk. Then we started to plug the mobile hard disk into the Mac for installation. This time it went quite well and there was no blue screen restart problem. The system has finally been installed, and it has finally made progress. Then I began to install various tools in win10: Visual Studio 2013, Tortoise Git, Navicat Premuim, etc. I originally wanted to install mysql in Win10, and decided to install mysql directly on the Mac due to the Virtual Machine storage space problem. The nightmare started again.

It is not complicated to install mysql. Download the dmg file from the official website, double-click it, and install it as prompted. However, in order to reset the root password of mysql, replace it with a familiar password instead of a temporary password. So we started our password reset journey. It is customary to search for related articles on Baidu. The procedure is as follows:

1. Open the preference settings in the bottom dock, find mysql, and disable the mysql service;

2. Go to the mysql/bin folder and obtain the Administrator permission to disable mysql authentication. Enter at the terminal:

Cd/usr/local/mysql/bin/

Sudo su

./Mysqld_safe -- skip-grant-tables &

Now you will see that the mysql service in the preference settings is enabled.

3. Set the new password and enter it in the terminal (or in the mysql/bin folder ):

./Mysql

Flush privileges;

Set password for 'root' @ 'localhost' = PASSWORD ('string corresponding to your new password ');

After all the above steps are completed, restart mysql and log on with the changed password. However, I want to connect to mysql under the host through Navicat in the virtual machine. I tried to configure the mysql connection information and then click "test connection" to bring up "ERROR 1130: host 192.168.3.100 is not allowed to connect to this MySQL server "prompt. After this query, mysql does not grant other client connection permissions. Later, the authorization method was used for Configuration:

If you want to allow myuser to connect to the mysql server from a host whose ip address is 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. By the way, it is also troublesome to adjust the network connection to non-Shared Mode in win10 in Fusion. I will change it to wi-Fi, in this way, the ip address of win10 and the ip address of the mac host are in the same CIDR block, so there is no problem connecting to mysql. Otherwise, the connection will be successful only through Bridge or NAT forwarding.