Re: Using skip-grant-tables in MySQL 8.0.28

[zhu guan]

Skip-networking instructs MySQL not to listen for remote TCP/IP connections. This obviously is not ideal if MySQL is needed for use as a database server on a local network. I found that remote connection can be achieved through the following settings.

Step 1 – Create MySQL User with Remote Access

mysql> CRATE USER 'username'@'remote_server_ip_or_hostname' IDENTIFIED BY '';

You can also use ‘%’ instead of remote host to allow any remote host. For example:

mysql> CREATE USER 'username'@'%' IDENTIFIED BY '';

Step 2 – Grant the privileges to running MySQL server

mysql> GRANT ALL on *.* TO 'username'@'remote_server_ip_or_hostname';

Step 3 – Reload the privileges to running MySQL server

mysql> FLUSH PRIVILEGES;


If you add a remote user, you can use the user to connect remotely . Although I don't know if the understanding is right or not, it works very well.