I can't login to phpMyAdmin

[Tim Rowley]

This is a new install. Yesterday I got past a login problem by changing permissions and had entered phpMyAdmin last night and had tried to upload a database that was too big. I had already rewritten limits in php.ini but this morning remembered that I probably had to restart httpd and I also restarted mysqld. Now I can't get back in with my username and password. Do you have any ideas please.

[skurudo]

Try

Code: Select all

chmod 777 /var/lib/php/session

[Tim Rowley]

I did that yesterday and was into phpMyAdmin after that, but today I can't get in.
The login form page opens with a pink message box at the top saying "No activity within 1440 seconds; please log in again" which remains there after completing Username and Passwords and pressing Go. There is no error message.
I've just checked that these permissions were still there and they are.

[skurudo]

Clear cache and try again, and check error log.

[Tim Rowley]

I have cleared the cache and tried again. Nothing happened again, but this time there was no pink message box saying "inactive for more than 1440 seconds, sign in again". Nothing at all happened and no error message on screen.

I downloaded var/log/ mysqld.log but I don't know what I'm looking at.

[skurudo]

open up config.inc.php in the root phpMyAdmin directory and add this setting (anywhere):

Code: Select all

$cfg['LoginCookieValidity'] = <your_new_timeout>;

28800 for example
and restart apache

[Tim Rowley]

Thanks Skurudo
I've done that : I restarted httpd assuming that's what you meant by restart Apache, and then I cleared browser cookies, and still nothing happens.

[skurudo]

Thanks Skurudo
I've done that : I restarted httpd assuming that's what you meant by restart Apache, and then I cleared browser cookies, and still nothing happens.

Nothing - it's the same error "inactive for more than 1440 seconds" or...?
Try to clear sessions from /var/lib/php/session and log in.

[Tim Rowley]

There is no error message.
I'm wondering if I should reinstall everything adn perhaps choose Centos 7

[skurudo]

There is no error message.
I'm wondering if I should reinstall everything adn perhaps choose Centos 7

Where do you look error messages? ;-)