How to connect DB through Software?

Discussion in 'Databases' started by imranamen6, Dec 13, 2010.

  1. #1
    I got a client who gave me the database details but no cpanel access i dunno how to connect manually can some one help me ?

    Is there and windows based software which allows me to connect to the database?

    i have the database name, database username and database password.


    thanks in advance.
     
    imranamen6, Dec 13, 2010 IP
  2. shofstetter

    shofstetter Well-Known Member

    Messages:
    178
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    120
    #2
    What is the database platform MySQL Postgres MSSql ?
     
    shofstetter, Dec 13, 2010 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    To connect to mysql you can use several desktop softwares e.g. HeidiSQL. For other options visit the MySQL GUIs list.
     
    mwasif, Dec 14, 2010 IP
    imranamen6 likes this.
  4. imranamen6

    imranamen6 Active Member

    Messages:
    947
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    98
    Digital Goods:
    1
    #4
    Thanks but the site is hosted with bluehost.com and when i try it says access denied.


     
    imranamen6, Dec 14, 2010 IP
  5. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #5
    MySQL user must have privileges to connect remotely. Ask your client to provide you any web based tool or grant access to mysql user to connect remotely.
     
    mwasif, Dec 14, 2010 IP
  6. shofstetter

    shofstetter Well-Known Member

    Messages:
    178
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    120
    #6
    shofstetter, Dec 14, 2010 IP
  7. zhisede

    zhisede Peon

    Messages:
    103
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #7
    If you are denied, mostly because the host doesn't allow remote database connection before your IP is added to their "allowed ip list". For such situation, you will need to have a static IP first and then contact the host asking them to add your ip to the "allowed ip list".
     
    zhisede, Dec 14, 2010 IP
  8. imranamen6

    imranamen6 Active Member

    Messages:
    947
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    98
    Digital Goods:
    1
    #8
    thanks for all to reply. i will contact the client to give me the cpanel details.
     
    imranamen6, Dec 17, 2010 IP
  9. fancymouj

    fancymouj Peon

    Messages:
    5,019
    Likes Received:
    134
    Best Answers:
    0
    Trophy Points:
    0
    #9
    hi mate

    Nantronix DB Connect OCX - This tool provides you with the ability to obtain a connection string to any ODBC compliant datasource or any SQL Server or Microsoft Jet 4.0 OLE DB database. When invoked, this OCX will display a Datasource Properties dialog box that will gather information from the user about the database that they want to connect to, then the OCX will pass back an ADO compliant connection string to your application. Only one line of code provides you with a valid verified connection string!

     
    fancymouj, Dec 18, 2010 IP
  10. getbestproduct

    getbestproduct Peon

    Messages:
    140
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    there is a freeware you can use name mysql administrator
     
    getbestproduct, Dec 23, 2010 IP