MySQL Database Sharing with Developers

SaadK

• July 28, 2015 23:53

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

  • July 29, 2015 10:24

  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.

  0
• 

  SaadK

  • July 29, 2015 14:46

  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.

  0
• 

  ModServ

  • July 29, 2015 15:46

  What's the firewall software you are using (IPTables - CSF - APF)? And if you have "skip-networking" in /etc/my.cnf, remove it.

  0
• 

  SaadK

  • July 29, 2015 16:02

  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?

  0
• 

  cPanelMichael

  • August 12, 2015 18:43

  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.

  0

Please sign in to leave a comment.