Jump to content


Photo

Finding Mysql server...


  • Please log in to reply
3 replies to this topic

#1 ToonMariner

ToonMariner
  • Members
  • PipPipPip
  • Advanced Member
  • 3,342 posts
  • LocationNewcastle upon Tyne, UK

Posted 17 October 2006 - 09:56 AM

Hi,

Not sure if this is a mysql issue or not so - placed it here in the hope of a quick reply.

I have apache 2.0.29 php 4.4.4 and mysql 4.1 installed on my local machine.

phpmyadmin says it can't connect through the auth type and says upgrade my version of mysql....

NOW

when I run phpinfo() it says i have mysql v3.23.29 running!!!!! - but I have installed 4.1!!!!

I cannot find any other version of mysql on this machine (doesn't mean it isn't there)...

could anyone be so kind as to tell me what action I could possibly take to fix this? what config settings I need to check or anything else you think could be causing this...
follow me on twitter @PHPsycho

#2 HuggieBear

HuggieBear
  • Members
  • PipPipPip
  • Advanced Member
  • 1,899 posts
  • LocationEngland, UK

Posted 17 October 2006 - 10:26 AM

Toon,

Is the exact error:

Could not connect to MySQL: Client does not support authentication protocol requested by server;


HTH  ;)
Huggie
Advice to MySQL users: Get phpMyAdmin and test your queries work there first, take half the hassle out of diagnosis, also check the reserved words list.

Links: PHP Docs :: RegEx's :: MySQL :: DevGuru :: w3schools

#3 ToonMariner

ToonMariner
  • Members
  • PipPipPip
  • Advanced Member
  • 3,342 posts
  • LocationNewcastle upon Tyne, UK

Posted 17 October 2006 - 10:27 AM

yes

the thing that bothers me is that php sees mysql version 3.23.49 - but yes that is the issue


follow me on twitter @PHPsycho

#4 HuggieBear

HuggieBear
  • Members
  • PipPipPip
  • Advanced Member
  • 1,899 posts
  • LocationEngland, UK

Posted 17 October 2006 - 10:42 AM

It's due to password incompatibility....

Check out this link DigitalPeer and I hope you have root access!

Regards
Huggie
Advice to MySQL users: Get phpMyAdmin and test your queries work there first, take half the hassle out of diagnosis, also check the reserved words list.

Links: PHP Docs :: RegEx's :: MySQL :: DevGuru :: w3schools




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users