I am having trouble with dreamweaver connecting to mysql. i amr unning mysql 5 and php 5 on a apache server, i have tested the php and it works.The mysql is running but dreamweaver does not want to connect to the databse specified, it give the error "unidentified error has ecoured", this happens when i try connecting to a databsse using the desing mode of dreamweaver when i enter the code mode and type;

$host="hostname"
$DB="database"
$user="username"
$passwd="passwd"

mysql_connect($host, $user, $passwd)
or die('Unable to connect to server ' . $host);

he gives me a white page and no error, this must mean he finds the server but cant connect, so please if anyone can shed some light one the situation...

What is showing in the mysql logs?

You need to see if mysqld sees the connection, then track it from there..

Can you connect with the mysql client ok?

okay, give me the deatils, how do i connect wiht client, how do i check logs, im a real noob wiht linux, only know a bit so..details

I am assuming mysqld is installed on a separate Linux machine..

Logs are in /var/log/mysql.log
To view it while it is running, do tail -f /var/log/mysql.log in a console as root.

The client name and password need to be given permission to bind to an mysql table.
If this sounds foreign to you, it probably hasn't been done yet..
From a console on the server do /bin/mysqladmin version & /bin/mysqladmin variables to make sure you can connect to the server from it's local user.

Next is bin/mysqlshow
then bin/mysqlshow mysql
then bin/mysql -e "SELECT Host,Db,User FROM db" mysql
These prove that the server can be talked to from a local connection.

Next look at netstat -tlnp and see if it is listening on more than only 127.0.0.1:3306
If it is just 127.0.0.1 check /etc/mysql/my.cnf and change the line "bind-address = 127.0.0.1" to the correct interface ip number.
Also check if the line "# skip-networking" has the hash at the beginning. If not, put in a hash.
To edit the file, use nano or pico. eg nano /etc/mysql/my.cnf or a text editor from the menu.

Then restart mysqld and test again.

i tried that, but still i get the error. i tried telnet <mysqlip> 33306 on my windows machine, but it made an error, what can be wrong there, maybe that is the cuase of my issue?