SQL Browser & MySQL5.0

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
wildteen88
Posts: 2
Joined: Sun May 07, 2006 6:59 pm

SQL Browser & MySQL5.0

Post by wildteen88 »

Hi I have just bought RapidPHP 2006 and I am currently getting used to it and playing around with the many different features. One feature I am having a little problem with is the SQL Browser.

I have a local install of Apache2, PHP5 and MySQL5 which was all installed and configured manually.

Now when I double click the database connection trhat I setup which is a simple test connected to a test database I have setup. When I click the refresh icon in the SQL Browser I get the following error message:

Code: Select all

SQL Error: Client does not support authentication protocol by server; consider upgrading MySQL Client.
What should I do now? Any tips please. I will try the driver update again.

Any help would be greateful!

TIA
Top
HyrumR
Posts: 19
Joined: Fri Mar 10, 2006 5:49 pm

Post by HyrumR »

The driver doesn't work with MySql unless you use the old password encryption. What you need to do is go to the MySql command line and change the password:
mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

Hopefully we'll soon see an upgrade that fixes this problem, but for now that's the only workaround that I know of.
Top
wildteen88
Posts: 2
Joined: Sun May 07, 2006 6:59 pm

Post by wildteen88 »

thanx HyrumR that has sorted. I can now use SQL Explorer in rapidPHP 2006.
Top
Post Reply

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