Problems setting up a MySQL connection, Please Help!


Oct 14, 2008

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.



Technical Product Specialist
Nov 29, 2006
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.