Run this command:
GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";
- USERNAME is the username that you would like to create.
- IP is the public IP address of your remote connection.
- PASSWORD is the password you would like to use for this username.
You now must flush MySQL's privileges. Run this command:
Run this command to exit MySQL: