The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Database Sharing with Developers

Discussion in 'Database Discussions' started by SaadK, Jul 28, 2015.

  1. SaadK

    SaadK Member

    Joined:
    Jul 28, 2015
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Saint Joseph, MI
    cPanel Access Level:
    Website Owner
    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.
     
  2. ModServ

    ModServ Well-Known Member

    Joined:
    Oct 17, 2006
    Messages:
    332
    Likes Received:
    5
    Trophy Points:
    18
    Location:
    Egypt
    cPanel Access Level:
    Root Administrator
    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.
     
  3. SaadK

    SaadK Member

    Joined:
    Jul 28, 2015
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Saint Joseph, MI
    cPanel Access Level:
    Website Owner
    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.
     
    #3 SaadK, Jul 29, 2015
    Last edited by a moderator: Jul 29, 2015
  4. ModServ

    ModServ Well-Known Member

    Joined:
    Oct 17, 2006
    Messages:
    332
    Likes Received:
    5
    Trophy Points:
    18
    Location:
    Egypt
    cPanel Access Level:
    Root Administrator
    What's the firewall software you are using (IPTables - CSF - APF)?

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

    SaadK Member

    Joined:
    Jul 28, 2015
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Saint Joseph, MI
    cPanel Access Level:
    Website Owner
    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?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,667
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page