Hi You have have to give remote access. I think you can give it with MySQL Administrator on User-Admin with (somehow) <user>@% or <user>@ip-address.
Good luck Werner > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 21 Aug 2008 12:50:28 +0200 > From: Steven Lobbezoo <[EMAIL PROTECTED]> > Subject: Re: [Gambas-user] Mysql connection bug/problem ? > To: mailing list for gambas users <gambas-user@lists.sourceforge.net> > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset=utf-8 > > Did you check the Mysql database in mysql ? > In the users records there is also reference to the host the user is > allow to use. > If it's marked localhost, that's your problem. > > Regards, > Steven > > > Le jeudi 21 ao?t 2008 ? 13:39 +0300, Kamau Gatheru a ?crit : > > >> As a matter of fact I have, >> >> Here is a sample of the /etc/hosts, listing >> my database servers >> >> 127.0.0.1 localhost >> 127.0.1.1 MvServer >> 192.168.1.200 Mvserver >> 192.168.1.100 Server >> .... >> >> surprisingly even on the local machine (MvServer) >> only .host = "localhost" works >> >> >> >> On Thu, Aug 21, 2008 at 10:18 AM, Marcelo Confortino >> <[EMAIL PROTECTED]> wrote: >> >>> Kamau Gatheru escribi?: >>> >>>> Hi all, >>>> >>>> I have been trying to connect to a remote mysql server (within my network) >>>> and it seems all my local installations of Gambas cannot do that. >>>> Incidentally >>>> I discovered that the .Port element doesn't work. I can run the following >>>> code >>>> locally and it works fine. >>>> >>>> WITH Conn >>>> >>>> .type = "mysql" >>>> .host = "localhost" >>>> .Port = "4444" <------- I put the wrong port and it still >>>> works regardless >>>> .login = "user" >>>> .Password = "" >>>> .Name = "control" >>>> >>>> END WITH >>>> >>>> >>>> but when trying to connect to a remote computer using the correct >>>> parameters >>>> >>>> WITH Conn >>>> >>>> .type = "mysql" >>>> .host = "remotehost" >>>> .Port = "3306" <------- Correct port >>>> .login = "user" >>>> .Password = "" >>>> .Name = "control" >>>> >>>> END WITH >>>> >>>> I get an error ( Cannot open database: Unknown MySql server host 'The >>>> -remote-host' (1) ) >>>> or another error ( Cannot open database: Can't connect to MySql server >>>> on 'My -remote-host' (111) ) >>>> >>>> Could you please give me a work around or the proper procedure to >>>> connecting to >>>> a remote MySql database server. >>>> >>>> Thanks and best regards, >>>> >>>> Kamau Gatheru >>>> >>>> ------------------------------------------------------------------------- >>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>> challenge >>>> Build the coolest Linux based applications with Moblin SDK & win great >>>> prizes >>>> Grand prize is a trip for two to an Open Source event anywhere in the world >>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>> _______________________________________________ >>>> Gambas-user mailing list >>>> Gambas-user@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/gambas-user >>>> >>>> >>>> >>> This may seem obvious, but do you have 'remotehost' listed in >>> /etc/hosts? Bye. M. >>> __________________________________________________ >>> Correo Yahoo! >>> Espacio para todos tus mensajes, antivirus y antispam ?gratis! >>> ?Abr? tu cuenta ya! - http://correo.yahoo.com.ar >>> >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >>> Build the coolest Linux based applications with Moblin SDK & win great >>> prizes >>> Grand prize is a trip for two to an Open Source event anywhere in the world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> Gambas-user mailing list >>> Gambas-user@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/gambas-user >>> >>> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >> Build the coolest Linux based applications with Moblin SDK & win great prizes >> Grand prize is a trip for two to an Open Source event anywhere in the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> Gambas-user mailing list >> Gambas-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/gambas-user >> >> > > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user