MySQL Workbench allow remote connections

How can I allow remote connections to databases with MySQL Workbench?

Trying to connect to a database on an external host and it refuses the connection.

Port 3306 is forwarded correctly.

1 Answer

From the server:

GRANT ALL PRIVILEGES ON *.* TO '{USER}'@'{IP{' IDENTIFIED BY '{PASSWORD}' with grant option;

• {IP} is the IP you want to allow access. You can use % to accept any IP address
• {USERNAME} is the user you use to connect
• {PASSWORD} the password you use to connect

• To confirm the change do ...

  FLUSH PRIVILEGES;