Can't make a MySql connection

I'm going to guess this has been asked before but ZI can't seem to find a solution. I follow all the direction of the tutorials and I can't make a contection to the MySql databes on my local computer.

I've got all the MySql things up an running in the Sites folder under my user name, when I try to connect I get an unidentified error message then a "There's no testing server running on the server machine message. I've used "root" as the user name and the user name of the computer nothing has worked.

Any suggections?

Are you sure you installed Apache?

This Article might help:
How to set up a local testing server for Dreamweaver
144/

The user name and password it's looking for are the ones that you assigned to the database you setup.

Yes Apache is installed and the MySql administrator tells me the server is running. I have all my files in the folder Users/drubin(my username)/Sites

MySql is set to work with my user name and my computers password.

Your files have to be installed in the web root of the web server for Apache to see them.

It will only work with your computer name and password if they are the same as the database name and password you assigned when you created the database. MySQL doesn't do anything with your computer login information. It only cares about the database user name and password.

First off thanks for your help, I think it's great that folks like you are out there.

My files are if the web root of the Apache server.

When I try to connect I get a MySql error #2002.

Here's what the MySql connection screen in Dreamweaver says:
Connection name: connBSM
MySql server: localhost
User name: Root
Password: ••••••••
Database;

So is your web root something like:
C:\xampp\htdocs\

You haven't specified the database name.

I'm working on a MAC, the root is:

Users/drubin/Sites/

Hi drubin,

While this won't fix the problem you're speaking of, it is an alternative solution.

Have you tried MAMP? index.html

I have found it to be the best Apache/MySQL/Mac all in one solution on the block.

MAMP is free and MAMP PRO is available for a nominal fee... MAMP PRO even allows you to create virtual hosts - which is great if you're developing many sites at one time.

Cheers,

Brian

OK, I've downloaded MAMP and put my files in the htdocs folder and created a new site that specifies that foldr as the site root and I still get the same error message.

Go to the mamp control panel, does it show the MySQL Server as running in the top right hand corner?

try using the mySQL GUI Tools to access the MySQL Server:
5.0.html


If it is running and still have he same problem, see the following thread on the mamp forum:
viewtopic.php?t=679&start=0&postdays=0&postorder=asc&highlight=code+2002