MySQL Database Sharing with Developers

[SaadK]

Hello,

I'm trying to make just one of my MySQL databases for a website available to a developer for use but I'm stuck. I've made a user and added it to the database in question in Cpanel, but I still don't know how my developer will access the database.

Where does the developer need to use the user/password I have created for them to access the database?

I appreciate your help.

 

[ModServ]

Developer can access MySQL Database remotely if you open port 3306 for him to use and enabled MySQL networking, or he can work locally on your server.

 

[SaadK]

Thank you for your response.

Where must I go to enable MySQL networking? I assume I'll get the option there to open port 3306?

Thanks again

Actually, can you explain both in detail? I'm new to this so...

I appreciate it.

 

[ModServ]

What's the firewall software you are using (IPTables - CSF - APF)?

And if you have "skip-networking" in /etc/my.cnf, remove it.

 

[SaadK]

I don't know where I need to go to check which firewall software I am using...
Also, where do I have access to the cnf file?

 

[cPanelMichael]

Hello

You only have cPanel access based on your "Website Owner" entry in your profile. However, you should be able to add the developer's IP address via "cPanel Home >> Databases >> Remote MySQL". This allows remote hosts (servers) to access MySQL® databases on your account provided they know the database user's username and password.

Thank you.