Phpmyadmin login error

terhana
terhana used Ask the Experts™
on
Hi All,

I have installed Mysql 5.0 , Php 4.4 on one of my Redhat EL 3 server. I can connect with my database by typing
#mysql
I have installed phpMyAdmin 2.10.1 and configured the config.inc.php file like this way:

<?php

$cfg['blowfish_secret'] = 'ba17c1ec07d65003'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

$i = 0;
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */


$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'abc123';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

When i enter the URL in my browser for phpmyadmin. it load the page of phpmyadmin and asks for username and password. after entering the user "root"  and password "abc123"  it gives me an error :

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Can anyone help me to fix up this issue.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2004
Commented:
Because you are using MySQL 5.0, you need to use the newer mysqli extension. More information on it:

    http://us2.php.net/mysqli

In your configuration file, you need to have:

    $cfg['Servers'][$i]['extension'] = 'mysqli';

as well as the extension loaded (perhaps in your php.ini--it's been awhile since I've had to enable it).

Author

Commented:
Hi

Thanks for your help. I have PHP 4.4 and mysql 5. According to these steps i am trying to do with "./configure" script but there is no any option for --with-mysqli .

How i can install it or is there any otherwise to install this extension.

Thanks
Top Expert 2004

Commented:
Sorry for the late response; I'm sick today, so I fell asleep. What OS do you have?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Many Thanks for reply.

First of hall best wishes for your health.

I am using Redhat AS4. I have reinstalled Mysql 4.x and then i tried by running phpmy admin with "mysql" extension.

Now i can login but still i am getting few warnings while opening phpmyadmin page.

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

Cannot load mcrypt extension. Please check your PHP configuration.

How can i fix them up. are these extensions very necessary.


Please let me know

Author

Commented:
Here are my new configuration for phpmyadmin:

<?php
$cfg['blowfish_secret'] = 'ba17c1ec07d65003'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$i = 0;
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'ilyas';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>


Strange thing is that. If i using blank password for mysql and i am not putting in any password in this file then i can login with phpmyadmin and it gives some security exceptions. If i use a password for mysql and same i am putting in this config.inc.php file then it gives me error:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

While its not mysql 5.0 and its not related to mysqli cuz i changed it to 4.x which can support this php.

Kindly reply about this aswell.
Top Expert 2004

Commented:
I must confess I'm not too familiar with building PHP on an operating system since I'm stuck with Windows. However, I have checked the documentation for

    http://us2.php.net/mysqli

and you should be able to set an option to build with mysqli (under Installation section). The same should be applicable to the other extensions you mentioned. I don't know if the extensions are necessary to phpMyAdmin, but if it doesn't hurt you to enable them, they will ensure that it will run smoothly.
Top Expert 2004

Commented:
Yikes, I'm not too sure about your latest problem. I haven't had problems installing phpMyAdmin before, so I don't know if I can help. I'm very sorry.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial