help with local testing environment of php pages/mySQL/phpMyAdmin/Dreamweaver

[sock2me]

Basically, my goal has been to set up a local instance of php, mysql and phpMyAdmin so that I could test my php pages and the db content locally before I copied them up to the live server.

I've been working on this for days. My ISP does not allow remote connection to the db (hence my attempt to do it locally)

I installed mysql, phpmyadmin and made sure my Apache and php were working. I am now attempting to get into the phpMyAdmin scrren in order to built my table. I am very very new to all of this.

Currently, I cannot connect with the mysql db via phpMyAdmin. I get this error:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I tried adding a password into the config.inc.php file (didn't help)
I tried adding a password to mysql and all I get are errors (I'm really not sure I'm doing it correctly though) I've been in Terminal and then I downloaded a program: "My Query Browser". Tried to run

SET PASSWORD FOR 'root' = PASSWORD('new_pass');

this did nothing but give me an error

So I read somewhere to try this:

/usr/local/mysql/bin/mysqladmin -u root password buttonbling
(I want my new password to be buttonbling)

And I got this error:

/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Whats the most basic way for me to check that I have mysql running correctly on my G4? Why might I not be able to connect to the mysql via the phpMyAdmin?

How far back do I need to take this - shall I uninstall everything and start from scratch?

I did install that little app that will reboot mysql if I were to shut my computer off and restart.

Thank you for any help you may be able to provide

[eric2006]

You might want to try and re-install mysql. Then you waill have a blank password for root, and phpmyadmin will have no problem logging in. The same thing happened to me, after I changed the password for the root user. Apparently, you need to have the password for the root user in the phpmyadmin files (in some config file, I don't remember which off the top of my head)