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.

Problems setting up a MySQL connection, Please Help!

Discussion in 'General Discussion' started by plastik9, Oct 14, 2008.

  1. plastik9

    plastik9 Member

    Joined:
    Oct 14, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    First of all I am going to apologise for the question because I am new to creating web sites and so I will most likely not make much sense. I couldn't find a clear answer to this using the search function so hopefully this hasn't been asked already.

    My problem is with setting up a MySQL connection in Dreamweaver.

    I have been able to do it using Apache, PHP and MySQL. I set up the connection as follows:

    MySQL server: localhost
    Username: root
    Password ******

    This works fine. My problem is that I don't know how to get this online and working on my web server using CPanel. I have replaced the Username and Password as appropriate, but I am unsure how to know the address of the MySQL server. I have used my domain name, is this correct?

    In Dreamweaver the connection does not seem to be made to the server. I have the error message:

    "Client does not support authentication protocol requested
    by server; consider upgrading MySQL client"

    I understand that this is something to do with my version of Dreamweaver being old and the version of MySQL being above version 4.0. I have even tried to follow some instructions on resetting the password to pre-4.1 style.

    The truth is I have no idea what I am doing. I know very little about MySQL commands etc. I only know how to set up the databases.

    I am quite desperate for help, I have spent days trying to work this out. Please could someone explain to me in simple terms how establish this MySQL connection in Dreamweaver MX 2004?

    Thankyou in advance for your help, it will be massively, massively appreciated.

    Paul
     
  2. plastik9

    plastik9 Member

    Joined:
    Oct 14, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Please can anyone help? Does my first post make sense?
     
  3. 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
    A commonly overlooked thing in these scenarios is to grant your workstation access to connect to MySQL. By default, cPanel/WHM environments do not permit any external server sot connect to MySQL.

    Simply go to your cPanel interface and click on Remote SQL. Then add your workstation's IP address. If you are on a connection with a dynamic IP address, you may need to repeat this process again in the future as your IP address changes.
     
  4. plastik9

    plastik9 Member

    Joined:
    Oct 14, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Thank you!
     
Loading...

Share This Page