Dreamweaver - localhost mySQL database won't connect to my php site
I have a php site that has been running off a mySQL database very well.
I want to make some changes to the site but I want to run a testing environment on my local computer.
I'm using a Macintosh running Leopard. I installed MySQL and activated php and have the site running locally except that I can't connect to the local database from my local site. I'm using Dreamweaver to make the connection file. I'm using local host with root and no password.
I used navicat to duplicate the database from what it online. I am able to connect to this database on my localhost and everything seems fine until I try to connect to it using my Dreamweaver. Then it can't locate the database. I checked the settings and they are the same as on Navicat, which sees the database fine.
Also I'd like to put a password on the root user. How do I do that?