MySQL Connection Error

Post your questions and problem reports here

Moderator: kfury77

Forum rules
Please try to follow these guidelines. This will help to receive faster and more accurate response.
  • Check the Support section of the corresponding product first. Chances are you will find your answer there;
  • Do not create new topics for already reported problems. Add your comments to the existing topics instead;
  • Create separate topic for each problem request. Do NOT post a number of non-related problem reports in a single topic;
  • Give your topic a meaningful title. Titles such as "A question," "Bug report" and "Help!" provide others no clue what your message is about;
  • Include the version number of the software you are using;
  • This is not an official customer support helpdesk. If you need a prompt and official response, please contact our support team directly instead. It may take a while until you receive a reply in the forum;
Post Reply
ImOk
Posts: 4
Joined: Thu May 25, 2006 5:45 pm

MySQL Connection Error

Post by ImOk »

I just download the Webbuilder 2006 demo.

I like it.

I tried to create an SQL connection using MySQL 5

When I double click to connect it gives following message:

"Client does not support authentication protocol requested by server. Consider upgrading MySQL client."

I can connect using the MySQL Administrator and view all the databases. What can I look for?

Thanks
Top
User avatar
chrisjlocke
Top Contributor
Posts: 995
Joined: Mon Aug 01, 2005 4:12 pm
Location: Essex, UK
Contact:
Contact chrisjlocke

Post by chrisjlocke »

How are you creating the SQL connection? Does your host support MySQL 5? Most are still using 4.
Apart from the code being written in WeBuilder, I can't see how this is a WeBuilder issue? (or am I missing something?)
The code wasn't written by the program was it? (eg, a wizard, or template)
Top
ImOk
Posts: 4
Joined: Thu May 25, 2006 5:45 pm

Post by ImOk »

chrisjlocke wrote:How are you creating the SQL connection? Does your host support MySQL 5? Most are still using 4.
Apart from the code being written in WeBuilder, I can't see how this is a WeBuilder issue? (or am I missing something?)
The code wasn't written by the program was it? (eg, a wizard, or template)
Sorry I was not not clear.

This happens when I am using the WebBuilder's SQL Explorer and create the connection there.

Goto View/SQL Explorer and then Add Connection

Thank you.
Top
User avatar
chrisjlocke
Top Contributor
Posts: 995
Joined: Mon Aug 01, 2005 4:12 pm
Location: Essex, UK
Contact:
Contact chrisjlocke

Post by chrisjlocke »

Aah, never knew that was there!
Again, do you know what database version your host supports?
Can't try this at work (my host supports MySQL 4) as I'm behind a web proxy, but will do when I get home.
Top
ImOk
Posts: 4
Joined: Thu May 25, 2006 5:45 pm

Post by ImOk »

chrisjlocke wrote:Aah, never knew that was there!
Again, do you know what database version your host supports?
Can't try this at work (my host supports MySQL 4) as I'm behind a web proxy, but will do when I get home.
It's on my local machine and its version 5.0.19-NT

Thank you.
Top
User avatar
chrisjlocke
Top Contributor
Posts: 995
Joined: Mon Aug 01, 2005 4:12 pm
Location: Essex, UK
Contact:
Contact chrisjlocke

Post by chrisjlocke »

Nope, doesn't work for me either, except I get an 'Access Denied' error.
I suspect however, that its not compatible with MySQL v5 anyway, as the drivers you can download are only for v4 and v4.1

Image
Top
flz
Posts: 22
Joined: Thu Jul 14, 2005 8:58 am

Post by flz »

have you looked here?
http://forums.blumentals.net/viewtopic.php?t=1149
Top
ImOk
Posts: 4
Joined: Thu May 25, 2006 5:45 pm

Post by ImOk »

That fixed it!

Thanks.
Top
Post Reply

Return to “HTMLPad / Rapid CSS / Rapid PHP / WeBuilder Support”