PPHMyAdmin - Error Logging In

cenocre

Setting up PHPMyAdmin for the first time. The log in page appears, but every time I try to log in I get:

#1045 Cannot log in to the MySQL server

.
MySGL is running fine and I can log in both locally and remotely with various admin programs.
Any ideas?

jxxaxxy

Really not enough info to help you.
Which version of mysql are you running.
Which version of php.
Are you upgrading from an old version of php/mysql.
Is the mysql server on same machine. If not then you will need to point it to the right server and use port 3306 if my memory serves me right.
So there could be a few issues. However, I run Abyss 2.7, mysql 5.5.23, php 5.3.10 and latest version of phpmyadmin. All on same machine with no issues. Generally you can log into it with no extra steps needed.
Also try dumping your temp files from your browser. Changing the blowfish will cause issues.

cenocre

Abyss 2.7
PHP 5.3.8
MySQL 5.0.77
PHPMyAdmin 3.5.0
Running on same machine as Abyss.
Tried with and without this line in the config

$cfg['PmaAbsoluteUri'] = 'DOMAIN/scripts/phpmyadmin/';

and with this line as

$cfg['Servers'][$i]['host'] = '127.0.0.1';

and

$cfg['Servers'][$i]['host'] = 'localhost';

Not clear what you mean about "Changing the blowfish". Are you referring to encryption?

jxxaxxy

Yes encryption. I am betting the issue has to do with how you are connecting to mysql. I think by default phpmyadmin, at least newer version are connecting mysqli.
The mysqli extension is designed to work with MySQL version 4.1.13 or newer, or 5.0.7 or newer.
It show that your should be supported but you can try using mysql and see if that fixes the issue.
Try changing it to mysql and see if it will connect then.
Also did you try using it without any config setup with just default?
Also you are on a very old version of mysql. Any thought on upgrading to newer version 5.5???

cenocre

As I mentioned above I have tried the default, but the MySQLi may have been the initial problem.
Changing that still did not work.
My version of MySQL was supposed to have worked with PHPMyAdmin, but I did just upgrade to the latest version, 5.1.40 that works with PPC processors.
With just the single change to the default config from MySQLi to MySQL, it now works.
Thanks

cenocre

jxxaxxy

Good deal. I know with php 5.3 they made some changes in how it connects with myslnd being the default. This could also be an issue with your older version of database. But glad you got it going!!!