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;
