Dreamweaver - can't connect to local mysql

Author

can't connect to local mysql

peterkienle

2004-08-24, 4:15 am

I am just evaluating Dreamweaver MX 2004. Well, actually I ordered a copy
already.

But now I am stuck with mysql. I *think* I have everything set up correctly.
Running a local server here on Mac OS X. mysql, php4, are running fine but the
same hostname, user & password only give me a 'Unidentified error has occured'
in Dreamweaver. When I try to Select a database from the mysql connection
panel I get a more elaborate message telling me about an 404 - the
_mmServerScripts folder is not there. Now the funny thing about that is that
when I open my root folder (the one localhost defaults to) in the Finder there
is _mmServerScripts but it is not showing in the listing within Dreamweaver.
Maybe that's as it should be.

Anyway, I have spent all day on this and I have it. Something is wrong and I
can't figure it out.

Peter

Alexandru COSTIN

2004-08-24, 4:15 am

Hi,
The _mmServerScripts folder is NEVER shown in Dreamweaver file list
(they have a hardcoded filter to not show it)

I suggest you go and try our PHAkt server model, we have in the last
version very solid error reporting for the connection.
http://www.interaktonline.com/phakt/

This technote might also help
http://www.interaktonline.com/produ...dId=0&id_thn=57

Alexandru

peterkienle wrote:

>I am just evaluating Dreamweaver MX 2004. Well, actually I ordered a copy
>already.
>
> But now I am stuck with mysql. I *think* I have everything set up correctly.
>Running a local server here on Mac OS X. mysql, php4, are running fine but the
>same hostname, user & password only give me a 'Unidentified error has occured'
>in Dreamweaver. When I try to Select a database from the mysql connection
>panel I get a more elaborate message telling me about an 404 - the
>_mmServerScripts folder is not there. Now the funny thing about that is that
>when I open my root folder (the one localhost defaults to) in the Finder there
>is _mmServerScripts but it is not showing in the listing within Dreamweaver.
>Maybe that's as it should be.
>
> Anyway, I have spent all day on this and I have it. Something is wrong and I
>can't figure it out.
>
> Peter
>
>
>

Joaquim Lopes

2004-08-26, 12:18 pm

Peter,

to be sure that mysql and PHP are running do the following:
1- Launch Terminal
2- type PHP -v [if everything is OK you will get the PHP version and some
other info]
3- type mysql -u root -h localhost -p
4- if you are prompted for a password type the mysql root password (not to be
confused with your system root password) [if everything is OK you will get some
info about the mysql server]
Hope this helps.

gareth

2004-08-26, 12:19 pm

This means that your site definition is setup incorrectly, DMX is trying to
connect to mysql using the _mmServerScripts files, but because the paths are
incorrect in the site definition it cant find them, and so can`t connect.

See my troubleshooting guide at:

http://www.dreamweavermxsupport.com...e&pid=60&sid=61

It explains how the connection process works, and gives troubleshooting tips
to help you solve this.

--
Gareth - TMM Dreamweaver
http://www.dreamweavermxsupport.com/
http://www.garethdp.com/

PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
http://www.phploginsuite.co.uk/

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox