Connecting to mysql with phpMyAdmin

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

Connecting to mysql with phpMyAdmin

Post by greeneel »

Helo,

I am setup phpmyadmin 2.8.0.1 to run with already setup Apache 2.0.47 , php 4,3,3 and mysql 5.0.18nt on a XP professional Box.. I followed the instructions in the manual and set everythig up including creating the config.inc.php file to include the username and password for the Mysql Server. After all this I brough up http://localhost/phpMyAdmin/ in my browser and it gave me the following error:

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

I am abit lost as to what client this is refering too, I think I have the last stable version on phpMyAdmin

any ideas?
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

try setting to the password to your mysql user to the old password hash.

Code: Select all

set password for root@localhost = old_password('somepassword');
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

Post by greeneel »

hi, don`t mean to be ignorant but, this is set within my.ini ? ..

or i just run it from the cmd line?
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

no, just run that 'query' from within the MySQL cli...substituting (of course) your username and password that you want.
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

Post by greeneel »

AHHHHHHH, LOLOLOL ROFL .... Thx Mate...
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

Post by greeneel »

Hi ,

This is what i did to no avail,

used username and pass to login as root and executed the follwoing

-> SET PASSWORD FOR root@localhost = OLD_PASSWORD ('mypass') , this went through but I still couldn`t load phpMyAdmin..
Also when i load it up now in my browser im not going direct to the index.php file i am getting the "Index of /phpMyAdmin" folder and i would have to then find and click the index.php file..

weird..
jrd
Forum Commoner
Posts: 53
Joined: Tue Mar 14, 2006 1:30 am

Post by jrd »


For your password :

Input : SET PASSWORD FOR 'root'@'localhost' = old_password('987654321');
Output: Query OK, 0 rows affected (0.05 sec)

SET PASSWORD FOR 'root'@'localhost' = old_password('987654321');
Query OK, 0 rows affected (0.05 sec)


For the index, in the httpd.conf file, make sure that index.php is there.

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
# The index.html.var file (a type-map) is used to deliver content-
# negotiated documents. The MultiViews Option can be used for the
# same purpose, but it is much slower.
#
DirectoryIndex index.html index.html.var index.php
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

Post by greeneel »

ok ...
jrd
Forum Commoner
Posts: 53
Joined: Tue Mar 14, 2006 1:30 am

Post by jrd »

ur welcome
Post Reply