Re: Not allow

[Christian Mack]

Kittiphum Worachat wrote:
> 
> Hi.
>     how can i solve this problem when i try to conncet to mysql server at linux with
> myodbc with win98 the error is
> 
>  : 1130 (Host '' is not allowed to connect to this MySQL server)
> 
>     Thanks
>     Kittiphum.

Hi Kittiphum

You have to set the priviledges of the mysql user witch tries to connect via MyODBC.
For example:
Given this:
* mysql user name is "winUser" and has a password called "winPasswd" 
* your win98 machine is called "win98.your.com"
* the database this user shall connect to is called "remoteDB"

You have to enhance the priviledges of "winUser" like this:
GRANT INSERT, UPDATE, DELETE, SELECT ON remoteDB.* TO winUser@stripped IDENTIFIED BY
'winPasswd'

Tschau
Christian