Two methods are available for Mysql remote connection configuration.

Two methods are available for Mysql remote connection configuration.

Two Methods for configuring Mysql remote connection

When you work in the company, you often encounter mysql databases stored on a certain computer. to connect to the mysql service, you must enable remote connection on the computer with the mysql service.

First:

Root @ ubuntu:/usr/local/MySQL # mysql-hlocalhost-uroot-proot; mysql> use mysql; mysql> insert into user (host, user, password, Select_priv, Insert_priv, update_priv, Delete_priv, Create_priv, Drop_priv, primary, File_priv, Grant_priv, primary, Index_priv, Alter_priv, primary, Super_priv, primary, show_view_priv, Create_routine_priv, struct, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv) VALUES ('%', // replace % 'with a fixed IP address and password ('Cap '), 'y ', 'y ', 'y', 'y '); mysql> flush privileges;

Second:

Root @ ubuntu:/usr/local/mysql # mysql-hlocalhost-uroot-proot; mysql> grant all privileges on *. * TO 'test' @ '%' identified by 'test' with grant option; // replace % mysql> flush privileges with a fixed IP address;

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!