[Gambas-user] MySQL Connect

[Benoit Minisini]

On Saturday 08 January 2005 23:37, John G. Ruff wrote:
> When I run the Database example program, I still get the same
> error:
>
>   Cannot open database: Client does not support authentication
>                         protocol requested by server; consider
>                         upgrading MySQL client
>
> I did a fresh install of Mandrake 10.1 Official (32 bit) on a
> different hard drive. I'm using Gambas 1.0.1. I downloaded &
> installed MySQL-Client 4.1.8a from MySQL.com.
>
> The server is running Mandrake 10.1 Official (32 bit) in runlevel
> 3 (text multi-user mode) and MySQL Server 4.1.8a.
>
> I am able to connect to, access and update this same server from
> my Visual Basic 6 / SP6 programs, so the credentials, etc.,
> should be OK.
>
> Any ideas what is wrong? I am at a loss for what to try next. I
> am just trying out Gambas, I really want to turn off my remaining
> Windows stuff and move entirely to Linux. Is it possible that the
> MySQL server is sending a request for something that Gambas does
> not / cannot respond to? Is anyone else successfully running
> anything similar to this?
>
> Thanks in advance for any help.
>
> jr
>
> -=-=-=-=-=-=-=-=-=-=-
>   John G. Ruff
>   Wayzata, MN USA
> -=-=-=-=-=-=-=-=-=-=-
>

Mmm... I have installed on my Mandrake 10.1 the following MySQL related 
packages:
- MySQL41-4.1.5-0.1mdk
- MySQL41-client-4.1.5-0.1mdk
- MySQL41-common-4.1.5-0.1mdk
- libmysql14-devel-4.1.5-0.1mdk
- libmysql14-4.1.5-0.1mdk

The MySQL server is running as it is configured by default on Mandrake, and I 
can connect to it with the user 'root' without any password.

The Gambas mysql driver just takes the values of of the Connection object 
properties and pass them to the mysql function mysql_real_connect().

Can you compare your mysql server configuration files with the original files 
installed on the Mandrake 10.1 ? Can you do the same thing with the contents 
of the 'user' table in the system database 'mysql' ?

Regards,

-- 
Benoit Minisini
mailto:gambas at ...1...