mysql allow remoe access

Solution:

When you have completed the installation of the MySQL into the server. You can run this command:

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';

Username - is the account you wish to create or use.

IP - is the physical IP address of the computer you wish to grant remote access to. [note: if you enter '%' instead of an IP address, that user will be able to remote into MySQL from any computer]

Password - is the password you wish to create if it’s a new user or the existing password of an existing account.

Once the command is sent and completed you must run this command afterward:

FLUSH PRIVILEGES;