[LUNI] Connecting Access to MySQL on Linux

[Eugene Teo]

How about the database? is it accessible from global? '%'? or
by the hostname?

see table db.

Eugene
-- 
eMail: eugene.teo at eugeneteo.net, admin at spug.org
www: http://www.eugeneteo.net/, http://www.spug.org/
main(i){putchar(182623909>>(i-1)*5&31|!!(i<7)<<6)&&main(++i);


On Thu, Dec 13, 2001 at 09:48:38PM -0500, David Callaghan wrote:
> Therein lay the source of my sorrow: I have granted priveleges. I can see my users through the command line or view them through KMySql 1.2.1. The IP address are assigned dynamically, so I've been using the hostname instead, which I understand is legal. However, the precocious error message assures me that the IP address is being denied.
> 
> >Hi there
> >
> >You must grant the user to access the MySQL server.
> >
> >pancreas:~$ bin/mysql -u admin -p mysql
> >
> >mysql> desc user;
> >>...
> >| Host            | char(60)      |      | PRI |         |       |
> >| User            | char(16)      |      | PRI |         |       |
> >>...
> >
> >update/add a user in this user table with the 192.168.x.x ip.
> >
> >You don't have to promise. We share because we care :)
> >
> >Eugene
> >-- 
> >eMail: eugene.teo at eugeneteo.net, admin at spug.org
> >www: http://www.eugeneteo.net/, http://www.spug.org/
> >main(i){putchar(182623909>>(i-1)*5&31|!!(i<7)<<6)&&main(++i);
> >
> >On Thu, Dec 13, 2001 at 09:06:44PM -0500, David Callaghan wrote:
> >> I have Linux running MySQL and some XP boxes with Access 2000 and the latest MyODBC. I have added the XP host names to MySQL and given them permissions, created a system DSN to attach to the Linux server (using the Samba server name) and I get an error that says 'Host 192.168.xxx.xxx not allowed to connect to this MySQL server'. 
> >> 
> >> I have seen this error posted on a number of mailing lists, but I haven't seen anyone post the solution.
> >> 
> >> If anyone has an answer, I promise to post it for the next person :)
> >> ______________________________________________________________________
> >> Linux Users Of Northern Illinois - Technical Discussion 
> >> luni at luni.org
> >> http://luni.org/mailman/listinfo/luni
> >
> >______________________________________________________________________
> >Linux Users Of Northern Illinois - Technical Discussion 
> >luni at luni.org
> >http://luni.org/mailman/listinfo/luni
> >
> ______________________________________________________________________
> Linux Users Of Northern Illinois - Technical Discussion 
> luni at luni.org
> http://luni.org/mailman/listinfo/luni