[Mono-devel-list] Looking for MySQL help

[Olivier Gaumond]

Even with MySQL 3.23.56 I get the exact same errors.  I tried with different
release of ByteFX.Data.MySQLClient and the only version I could use with Mono
on Redhat 9.0 is 0.65.  The latest version from CVS doesn't compile and seems
to depend on System.Windows.Forms.dll

I also tried to use the Mono.Data.Mysql provider.  I had to add a link:
$ ln -s /usr/lib/mysql/libmysqlclient.so.10 /usr/lib/libmySQL.so
Then I have been able to run the sample.  I get some errors complaining it
isn't able to load thread functions but I think it is because by default MySQL
is compiled without threading.

So I still can't connect to MySQL with the ByteFX.Data.MySQLClient provider and
I don't know if there is a problem with the provider or I did something wrong.

Olivier

 --- dkopko at stevens-tech.edu a écrit : > I'm a new mySQL user and a new C#
programmer and a new Mono user...  so bear
> with me.
> 
> Currently, I'm running Redhat 8.0 with the following packages installed:
> MySQL-client-4.1.0-0
> MySQL-devel-4.1.0-0
> MySQL-server-4.1.0-0
> mono-0.24-1
> mono-devel-0.24-1
> libgc-6.1-1
> 
> I am able to log into the mySQL server via the mysql command.  I have added
> tables and data.  I have compiled the first example at
> http://www.go-mono.com/mysql.html (ByteFX.Data.MySQLClient) without an error.
> (I
> have modified the connectionString variable to include my user data.) 
> However,
> running the .exe file produced gives the following error:
> 
> Unhandled Exception: ByteFX.Data.MySQLClient.MySQLException: Client does not
> support authentication protocol requested by server
> . Consider upgrading MySQL client
> in <0x000bc> 00 ByteFX.Data.MySQLClient.Driver:CheckResult ()
> in <0x000f5> 00 ByteFX.Data.MySQLClient.Driver:Authenticate
> (string,string,bool)
> in <0x00113> 00 ByteFX.Data.MySQLClient.Driver:Open
> (string,int,string,string,bool)
> in <0x00138> 00 ByteFX.Data.MySQLClient.MySQLConnection:Open ()
> in <0x00075> 00 .Test:Main (string[])
> 
> 
> I have not set up any particular authentication protocol on the server, so I
> imagine it is referring to the default one.  Do I need to switch
> authentication
> protocols within the server?  How would I do this if this is the case?
> 
> Thanks,
> 
> Daniel Kopko
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list 

__________________________________________________________
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca