I have planned a MySQL database design project with 2 of my friends and the plan is for us all to stay connected to the same database. I have created this database but it’s a hassle getting them to connect to it remotely.

I wrote these queries to grant one of them access

CREATE USER 'c*****a'@'%' IDENTIFIED BY 'c*****a*****';
GRANT ALL PRIVILEGES ON fgc.* TO 'c*****a'@'%';
FLUSH PRIVILEGES;

On his device he created a new MySQL Instance with hostname as my IP Address along with the user and password i created for him. Unfortunately, it had an error message saying:

Unable to connect with host.

For hostname, we tried both my Public IP Address and my IPv4 address from the ipconfig command in the commandline but it was not working.

I need your assistance here to help multiple remote users connect to a single mysql database