Mysql_(p)connect error using PHP/Mysql

[longsdale]

I am trying to get Dreamweaver to use PHP(5.0.3)/MySQL (4.1) and using an
apache web server. Cool, BUT when i try to make my datrabase connection i get
something like mysql_(p)connect error. When i looked onto the forum earlier
someone suggested changing the mysql using:
mysql> set password root@localhost = SET_PASSWORD ('password');
Well that was just great not only did not fix the problem but i cannot log
into the Mysql Administrator cause no password is excepted or something...
Please help what the hell is the answer and solution to this, it's beeen going
on for ages now.
Regards, Ian

[Kate2005]

If it's any consolation, I am having the same problem Ian. Review the
following site:
[url]http://www.thriftyplaces.com/html/dreamweaver__mysql__php___apac.html[/url]. It has
many suggestions on what to do about this common error. But I must admit, it
did not work for me. You never know, it might work for you. Let me know if it
works for you.

[longsdale]

Thanks i'll try this. But i'll still have trouble connecting if i can't re-set
the password in MySQL. Once i changed the 'SET PASSWORD' parameter?? how can i
change it back without uninstalling the whole thing and re-installing??
Ian

[Kate2005]

Ian,

I have successfully connected to MySQL. I decided to use ColdFusion MX 6.1 to
create a MySQL datasource. I had to upgrade from ColdFusion MX in order to
connect to mysql. If you plan to use ColdFusion, I recommend the following web
site:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170[/url].