List:MySQL ODBC« Previous MessageNext Message »
From:Christian Mack Date:June 9 1999 7:46pm
Subject:Re: Not allow
View as plain text  
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

Thread
Not allowKittiphum Worachat9 Jun
  • Re: Not allowChristian Mack9 Jun