phpmyadmin can't login

vladimir@ares · 12-30-2004, 01:18 PM

I got a problem with mysql on Gentoo 2.6.9

Apache is running perfectly (on port 8000),the same for php
mysql works fine from commandline
i can login with:

Quote:

mysql -u root -p 'password'

with 'password' my actual password

but when i go to http://localhost:8000/phpmyadmin/
i fill in 'root' and my password, and there seems to be a problem, cause phpmyadmin says "wrong username or password"
and i'm sure it's correct

i changed my my.cnf to:

Quote:

bind address = *

and

Quote:

#skip-networking

plz help me out, i've been googling for a few days now, and i really can't figure it out...

Thx

VlaDiMiR

vladimir@ares · 12-30-2004, 05:38 PM

ok, forget about that, i can't login from the commandline...
'can't connect to mysqld.sock'

i'm really getting pissed about this, don't know what's wrong with it ffs

alitrix · 12-31-2004, 03:00 AM

Guess php is configure to search for /tmp/mysql.sock (which isn't there) so phpmyadmin won't work

What you can do is:
find / -name mysql.sock
(or you use locate, if the database is up-to-date (you can do that by using `updatedb`))

If you find any (guess it's in /var/run/mysql/mysql.sock), then you can make a link to /tmp/mysql.sock

ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock (ofcourse, if it's there)

This should fix the problem