[Mono-list] MySql 1.1.7 problem also under 1.1.8

[Dilton McGowan II]

I modified your source to include the ByteFx
references and built and ran successfully.

The error you are seeing I'm pretty sure is the
password scheme problem in MySQL. Try this:

use mysql;
update user root set Password=OLD_PASSWORD('test');
flush privileges;

The flush privileges is critical! You should see zero
rows affected, this is normal.

For further assistance I recommend searching MySQL
site for documentation.

--- Kevin Flanagan <kevin.flanagan at bom.co.uk> wrote:

> Hello Martin - I have now tried the ByteFX driver
> (thanks for the
> suggestion), but it gives me a different error:
> "Client does not support
> authentication protocol requested by server;
> consider upgrading MySQL
> client". Given that it all runs ok with Mono 1.1.4
> (or the MS .NET runtime),
> I think that must be a red herring. Thanks for the
> input though.
> 
> Kevin.
> 
> -----Mensaje original-----
> De: mono-list-bounces at lists.ximian.com
> [mailto:mono-list-bounces at lists.ximian.com]En nombre
> de Martin Hinks
> Enviado el: 20 June 2005 16:05
> Para: Kevin Flanagan
> CC: mono-list at lists.ximian.com
> Asunto: Re: [Mono-list] MySql 1.1.7 problem also
> under 1.1.8
> 
> 
> Hmmm, seems to be a problem with Mono although I
> haven't tried to
> reproduced (yet)...
> 
> http://www.mono-project.com/MySQL
> 
> Try using the ByteFX (which isnt supported any
> longer but should work)
> as detailed on that page... might be some more info
> about your problem
> there...
> 
> Sorry, but this isn't my field of expertise but
> no-one else answered
> your previous query so thought id try and help.
> 
> Martin
> 
> On 6/20/05, Kevin Flanagan
> <kevin.flanagan at bom.co.uk> wrote:
> > I posted a problem recently using MySql with Mono
> 1.1.7 (which is fine
> under
> > Mono 1.1.4). For info, same problem exists under
> Mono 1.1.8. If anyone
> gets
> > a chance to reproduce it (details below) who knows
> MySql and Mono and
> might
> > be able to suggest a workaround, I'd be very
> grateful ... Thanks in
> advance
> > for any help.
> >
> > Kevin Flanagan.
> >
> > <Original post>
> > Environment: Windows XP, MySql 4.1, MySql
> Connecter/NET 1.0.4, Mono 1.1.4
> > and 1.1.7
> >
> > I recently upgraded a machine from Mono 1.1.4 to
> 1.1.7 and immediately had
> a
> > problem with MySql connections. Now I've put both
> versions on that machine
> > and have a two-line test program that does nothing
> more than connect to a
> > local MySql database. The test program runs fine
> under 1.1.4 but under
> 1.1.7
> > produces the error: "Unable to connect to any of
> the specified MySQL
> hosts".
> > Since the only difference between the two is the
> version of Mono, I'm
> > guessing it must be a Mono problem, but I've not
> been able to find any
> > information on it (though there is a thread which
> looks similar here:
> >
>
http://forums.mysql.com/read.php?38,27316,27316#msg-27316
> ). Has anyone
> > encountered this problem or found any resolution
> to it? Thanks in advance
> > for any info.
> >
> > <follow up>
> > Yes - no problem. Below is the simple csharp test
> I'm now using (which is
> ok
> > under 1.1.4 but not 1.1.7):
> >
> > using System;
> > using MySql.Data;
> > using MySql.Data.MySqlClient;
> >
> > namespace test
> > {
> >        /// <summary>
> >        /// Summary description for Class1.
> >        /// </summary>
> >        class Class1
> >        {
> >                /// <summary>
> >                /// The main entry point for the
> application.
> >                /// </summary>
> >                [STAThread]
> >                static void Main(string[] args)
> >                {
> >                        //
> >                        // TODO: Add code to start
> application here
> >                        //
> >
> >                        MySqlConnection conn;
> >                        conn = new
> MySqlConnection();
> >
> >                        conn.ConnectionString =
> "server=localhost;user
> >
> ID=root;password=test;database=test;pooling=false";
> >                        conn.Open();
> >
> >                       
> Console.WriteLine(conn.ServerVersion);
> >                        Console.ReadLine();
> >
> >                }
> >        }
> > }
> >
> >
> > _______________________________________________
> > Mono-list maillist  -  Mono-list at lists.ximian.com
> > http://lists.ximian.com/mailman/listinfo/mono-list
> >
> 
> 
> --
> Martin Hinks
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 
> 
> 
> 
> 
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 



		
____________________________________________________ 
Yahoo! Sports 
Rekindle the Rivalries. Sign up for Fantasy Football 
http://football.fantasysports.yahoo.com