Not only have you configured MySQL 8 for remote connections, you’ve also created a user with access to all databases and connected to the remote server with both the command line and a GUI.

Maybe I'm going about this the hard way, but here's what I'm trying to do:I need to run a script on a central workstation that will run a query on two remote MySQL boxes and return the output of ...

Thankfully, MySQL offers a handy command that goes a very long way to improve the security of your MySQL installation. ... In order to test remote access for the root user, ...

Search titles only By: Search Advanced search… ...

Then, I ran commands to check if the Linux server itself was configured to accept requests on MySQL’s port 3306. I used the iptables –list command, but found no references to INPUT port 3306.