[Gambas-user] Mysql connection bug/problem

[admin at ...1080...]

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 <steven at ...1652...>
> Subject: Re: [Gambas-user] Mysql connection bug/problem ?
> To: mailing list for gambas users <gambas-user at lists.sourceforge.net>
> Message-ID: <1219315828.6735.131.camel at ...1936...>
> 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
>> <mconfortino at ...1877...> 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 at 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 at 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 at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>
>>     
>
>