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.

Remote access to MySQL database

Discussion in 'cPanel Developers' started by Djedj31, Mar 16, 2008.

  1. Djedj31

    Djedj31 Registered

    Joined:
    Mar 16, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Hello,
    I'm looking for the URL I have to use to be able to connect to my MySQL database from my remote machine. Anyone could help please ?
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    To manage a MySQL database, you typically login to the cPanel interface and use phpMyAdmin.

    However, if you are connecting to a MySQL database from a custom application, you may wish to refer to the documentation for the language/API you are using to connect to the database.

    Don't forget to add your IP address to the permitted IP addresses allowed to access your database. You can do this by clicking on the "Remote MySQL" icon in the cPanel interface.
     
  3. LiNUxG0d

    LiNUxG0d Well-Known Member

    Joined:
    Jun 25, 2003
    Messages:
    206
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Gatineau, Quebec, Canada
    Hi,

    I would follow David's advice here. If you're coding in PHP, you need to follow the PHP MySQL object specifications. Usually you do not connect via a URL, you connet to an IP address or FQDN (Fully Qualified Domain Name) on port 3306 (standard MySQL port), using the username and password you assigned to the database.

    In PHP, for example:

    http://us2.php.net/manual/en/function.mysql-connect.php

    I'm a PHP developer, so, y'know... I'm biased! :D

    Let me know if you need anything else.

    Regards,
     
Loading...

Share This Page