- Install MySQL in Linux and configure it in a simple configuration.
- Start the MySQL service
Service mysqld Start
- Log in with an administrator user, usually by default without entering a password
-
Gain access to a specific user, where root
mysql> grant all privileges on * . * to root " @" % with grant option ; // > FLUSH privileges ; // required to enter a secondary command to make the change effective
- Turn off the firewall for Linux and Windows, and add the appropriate rules if you configure the firewall.
- Next install navicat for MySQL software on Windows, after installation, enter the interface select "Connect", the connection name is optional, IP address need to enter the following code on the Linux command station:
Ifconfig//Query native IP
Port is 3306, username and password for their database account password, my account is root here, password default is empty. Finally OK, double-click the connection.
Navicat connect to MySQL server in Linux
