Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Who is the MySQL client?


  • Please log in to reply

#1
magusbuckley

magusbuckley

    Member

  • Member
  • PipPipPip
  • 625 posts
Hello:

Using, for the first time, a PHP page to test a connection to a MySQL dbase. I'm using the sample code for this test from the hosting company. I get this error - "Client does not support authentication protocol requested by server; consider upgrading MySQL client". Now I'm trying to figure out - "Who is the client?" Is it my machine? Since their server is the one running the code, are they the client? I've checked all settings and then tried other sample code for testing and got the same result.

I can confirm if need be, but I'm pretty sure off the top of my head that the dbase is MySQL 5.0.

Any and all information will be greatly appreciated.

Thanks,

Magus
  • 0

Advertisements


#2
codingideas

codingideas

    Member

  • Member
  • PipPip
  • 13 posts
Does the SQL database allow remote connections? You should get familiarized with http://wb.mysql.com/

Edited by codingideas, 27 December 2010 - 11:31 PM.

  • 0

#3
magusbuckley

magusbuckley

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 625 posts
Sorry, I forgot I made this post or I would have come back to edit. This issue has been resolved. The problem was the version of IIS on the server I was using. Version 6 and below will not allow a PHP connection to the database. I contacted the hosting company who upgraded my IIS to version 7 and now everything is working just fine.

Thanks...

Magus
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP