RE: Good tutorial sites -- It's working TY

2001-02-15 Thread Mike 

Thanks for the info..it's working great here now.. Had to boot the windoze
to get it right.

Next I just have to get my ASTA Server and Client hooked in and I am good to
go..did a small test  and it seemed to be fine

If anyone happens to be Delphi type go to
http://www.astatech.com/support/servers.htm and download the MySQL Server
there..


Cheers

Mike

-Original Message-
From: Thiru [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 10:42 PM
To: Mike
Cc: Mysql
Subject: Re: Good tutorial sites



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
-> /'^'\
->( 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



-
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

Re: Good tutorial sites

2001-02-15 Thread Thiru 


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
-> /'^'\
->( 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

Good tutorial sites

2001-02-15 Thread Mike 

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
/'^'\
   ( 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