I have got the same confg and works perfect. WinNT & Linux MySQL.
Why dont U directly edit the user table of mysql DB.
Let Host be '%' and give some username & password.
mysql> insert into mysql.user
values('%','username',password('passwd'),'Y','Y',....'Y');
For test purpose let all priv fields be 'Y'.
Then try again it shud work.
Cheers!
Thiru
On Thu, 15 Feb 2001 22:28:31 -0700
"Mike" <[EMAIL PROTECTED]> wrote:
-> Hi All
->
-> Where are some good tutorial sites for beginners in the MySQL World. I read
-> the man pages as sugested but I am stuck on the GRANT HOST issues. I am
-> connecting my NT MyODBC to my LINUX's MySQL Server.
->
-> I tried
-> mysql> GRANT ...
-> ON *.*
-> TO myusername@"%100.100.100.1"
-> IDENTIFIED BY 'mypassword';
->
->
-> but I get a syntax error.
->
-> Good news is I figured out how to build tables<g>
-> /'^'\
-> ( o o )
-> -------------------------------------------------------oOOO--(_)--OOOo------
->
-> Mike Benzel
-> ---------------
-> To err is human, to really foul things up requires a computer.
-> .oooO
-> ( ) Oooo.
-> ---------------------------------------------------------\ (----( )-------
-> \_) ) /
-> (_/
->
->
-> ---------------------------------------------------------------------
-> Before posting, please check:
-> http://www.mysql.com/manual.php (the manual)
-> http://lists.mysql.com/ (the list archive)
->
-> To request this thread, e-mail <[EMAIL PROTECTED]>
-> To unsubscribe, e-mail <[EMAIL PROTECTED]>
-> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
->
->
�¨�æ�ê�l�Å�·�B
�æ�ë�µ�ã��I
---------------------------
�T�[�r�X�J���
�p�e�B�@(a) �e�B��
�à�ü�|2402
---------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
