Can't connect to MySQL. :-(

[MAbans]

Can't connect to MySQL for some reason. I just installed MySQL and I can manage it through the MySQL Admin tool but for some I can't connect to it via a web browser (phpMyAdmin). Any thoughts?

oh yeah I did run the

/usr/local/mysql/bin/mysqladmin -u root password new_password

but I get a

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

 

[ElDiabloConCaca]

How do you have the config.php file for phpMyAdmin setup? Did you change/modify the authentication scheme in config.php?

 

[MAbans]

Yeah I tried switching it from 'http' mode to 'config' mode and no such luck..

 

[ElDiabloConCaca]

Hmmm... strange. Did you try stopping and restarting the mySQL server, then trying to connect again?

 

[MAbans]

Yes sir. Its strange that I can connect through the mySQL Admin program available but not via webbrowser..

 

[ElDiabloConCaca]

Strange... and you added the correct php directives in the httpd.conf file? Sorry if this is elementary, I'm just trying to cover all the bases...

 

[MAbans]

Installed it using Marc Liyanage's installation

http://www.entropy.ch/software/macosx/php/

 

[ElDiabloConCaca]

Hmmm.. what version of mySQL are you using?

 

[simbalala]

If you're running 10.4.4 this thread may help.

http://www.macosxhints.com/article.php?story=20060111113313511&query=mysql

 

[MAbans]

4.1

Interesting.. that may have the key. I have to check when I get home tonight.