Quoted Text
I think all these damn issues go back to this mysql.sock file problem as each application on the server seems to be having trouble always finding this info (which from what I understand has the encrypted username/password). Arggg.....
Jim
If you upgraded or recompiled mysql at all
(or at anytime before these hairy boogers emerged) there is a mysql default username and password that the installation routine puts in.
It can break phpmyadmin and any other php includes that use authentication to talk to the php server.
I can write you a SQL query that will parse the db for the users and their privs, but I dont want to post it because if some surfer sees it I dont want them guessing our sites usernames and passwords to get to the db.
I got a PDF from mysql.org a while back and read through most of it
It talked about setting up accounts, privileges, etc to admin the server
the chapter you'll be most interested in is Administration
its available from -
http://dev.mysql.com/doc/ Try this
mysql -u 'root' -h'localhost -p
(enter your mysql root password here)
than try
'use database mysql;' (w/o quotes)
than
select * from mysql.user; (to view the users and privs in the mysql db
To validate your passwords do this -
SELECT PASSWORD('your_password_here');
To change priviledges add a new user do this -
SET PASSWORD FOR 'user'@'localhost' = PASSWORD('new_password');
This is all done from the mysql command line to get you around why the PHPMyAdmin GUI wont work, until you get that going again.
Slick tool,
I use it on a BSD box here at work (whenever the boss is out so I can surf Armorama)
HTH
Cheers
