MySQL Forums
Forum List  »  Newbie

Re: Using skip-grant-tables in MySQL 8.0.28
Posted by: zhu guan
Date: July 08, 2022 01:33AM

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.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.