Unable to login in phpmyadmin

[winger]

hi,

I've search about this, I see a lot of answer, but I didn´t found a way to fix that:

we have a box with php 5.2.4 and Mysql 5.0.45 and we can not use phpmyadmin, it keeps asking a password and none that we have works.

any help?

thanks!

 

[tanfwc]

Is MySQL 5 a new installation or upgrade from MySQL 4?

 

[winger]

hi there,

it's a new instalation

thanks.

 

[czotos]

I had the same problem on my new installation of DirectAdmin, but I managed to find something that works...

Login remotely to your server (via SSH I presume) and find this file...

/usr/local/directadmin/conf/mysql.conf

Try using the username and password which are listed in that file to gain access to phpMyAdmin.

 

[tanfwc]

Anyway, what username you try to login as?

 

[winger]

Anyway, what username you try to login as?

a regular user, created by a reseller.

 

[chatwizrd]

I have had to use:

/usr/local/directadmin/scripts/mysql.sh

to reset permissions before.

 

[winger]

hi,

it's not working for any of 20 user, do we need to run this for each one?

regards.

 

[chatwizrd]

No should be a global reset. Try updating phpmyadmin if its not current.

cd /usr/local/directadmin/custombuild
./build update
./build phpmyadmin

 

[winger]

No should be a global reset. Try updating phpmyadmin if its not current.

cd /usr/local/directadmin/custombuild
./build update
./build phpmyadmin

thanks, but still not working

 

[winger]

it seens that there is one more problem:

[root@server ~]# service mysqld restart
MySQL PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]

 

[winger]

it is working now!

with this error:

Your PHP MySQL library version 4.1.21 differs from your MySQL server version 5.0.51a. This may cause unpredictable behavior.

any help to fix that?

 

[tanfwc]

I believe your PHP is using the inbuilt mysql support, you got to rebuild it to use the mysql supplied library