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.

Customer mysql acces problem

Discussion in 'Database Discussions' started by pjmignone, Apr 14, 2008.

  1. pjmignone

    pjmignone Member

    Joined:
    Nov 19, 2007
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Hi:
    We have switched from hsphere to cpanel and am still getting the wrinkles out of our system.
    Customer's database system is no longer working and thier progerammer advises:
    Peter,

    "One if the things I used to do when you used HSphere, and one of the things I still need to do, is connect to our MySQL database by way of a local MS Access database located on my computer at work. This is necessary because information will need to be constantly exchanged between the databases. To do this, I would use ADO objects generated by MS Access and connect to the MySQL database by way of the ADO object's methods. To connect, I would use the "open" method of the "connection" object. The visual basic code would look like this:

    Set rconnect = New ADODB.Connection
    rconnect.Open "Driver=MySQL ODBC 3.51 Driver; Server=mysql.a1wpp.net; Data Source=cust_reports", "cust_master", "password"

    The connection string was, "Driver=MySQL ODBC 3.51 Driver; Server=mysql.a1wpp.net; Data Source=cust_reports"
    My username was, "cust_master"
    My password was, "password"
    This would work fine with HSphere, but it won't work with Cpanel. I'm writing to ask if anything has changed, such as the name of the MySQL server you use,"

    I am no programmer so I am not quite following it. But it seems to me that the name of the server has to be changed. In CPANEL would the mysql server's name be the domain name or something else. Can he connect using that code with the correct server name, usernaem, passwords etc. or there a security issue.. I notice there is a remote mysql section in cpannel. Please advise.
    Thanks!
    Pete
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
  3. pjmignone

    pjmignone Member

    Joined:
    Nov 19, 2007
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Thank You!
    :)
     
Loading...

Share This Page