Required:
1. Navicat(or any other one but thats what i use)
2. MySQL


Step 1: Adding the user
1. Start your MySQL server
2. Open Navicat
3. click the Manage users button




4. For host put the IP of the computer that will be connecting to this database
5. Put whatever you want for user and pass then click select all privileges.
in the end it should look something like below:


Step 2: Connecting remotely
1. make a new connection with the info from above like so, except for host you put the host of the database:


2. Press connect