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

Requirements: method of connecting mysql database on windows operating system 1: connect with SSH of Navicat

First, let's create a new connection in Navicat.

General (general)-only fill in (login username and password of the database)

Note: the hostname and IP address (localhost) and port (3306) do not need to be changed

two。 Then click-SSH

Note: configure the IP address, host user name and password of the server where mysql is located

3. Finally, click the test button in the lower left corner. (this will be ``ok).

# # #

Method 2: use IP address to remotely connect to mysql database

1. First, open Navicat to create a new connection. This time we directly enter the IP address of our remote host on the regular page | user name, password and port (3306) remain the same (database user name and password)

Next, we need to execute the following statement in mysql (open mysql remote permissions)

GRANT ALL PRIVILEGES ON *. * TO 'myuser'@'%' IDENTIFIED BY' mypassword' WITH GRANT OPTION

Grant all privileges on. To 'root'@'%'identified by' Flzx3qcfolk' With grant option

Query OK, 0 rows affected, 1 warning (0.01 sec) ~ ~

PS:myuser changes your database user name to root mypassword and changes to database login password.

After opening the remote permissions, we also need to modify the vim / etc/my.cnf file

Change bind-address = 127.0.0.1 to bind-address = 0.0.0.0

After modifying the configuration file, restart the mysql service:

(systemctl restart mysql) or

(systemctl stop mysql)-- (systemctl start mysql)

At this point, we can manipulate mysql on windows in two ways.

# # #

Note: the firewall must be turned off, otherwise it cannot be connected remotely.

Linux7 turn off the firewall:

1. View firewall status: systemctl status firewalld

two。 Check to see if the firewall service is started when powered on: systemctl is-enabled firewalld

3. Turn off and check the firewall: systemctl stop firewalld / systemctl status firewalld

4. Disable firewall (boot does not boot) systemctl disable firewalld / systemctl is-enabled firewalld

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.