Re: when i try connect since a client windows9x to mysql ...

2001-09-11 Thread Rene Tegel 

On Tue, 11 Sep 2001 00:25:20 GMT
Miguel Enriquez Alvarado[EMAIL PROTECTED] wrote:

 hi all
 
 this is my first question:
 
 when i try connect since a client windows9x to mysql (in a server linux rh 7.0), say 
me the next error:
   
 General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL PROTECTED] (using 
password YES) alias Test

You must grant user rights to mysql first.

use mysql console (eventually on server itself):

mysql -u root -p
mysql GRANT ALL ON *.* TO 'myname'@'192.168.1.1' IDENTIFIED BY 'a_password';
mysql flush privileges();

especially don't forget the flush privileges statement. Take a look at the manual for 
syntax grant statements:

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#GRANT

Another thing i would like to point out (not mysql-related) is that i see the usage of 
the '192.168.1.*' IP address. I assume that you use this on a local netwerk 
('subnet'). However, the range 192.168.*.*, with mask 255.255.0.0 is _not_ 'free' to 
use, only 192.168.0.* with mask 255.255.255.0 is. The first is a class B network, the 
second a class C. there _are_ internet addresses in use in the 192.168.* range, and 
you may well not reach them from your internal network.
If you have need for bigger subnet than class C, you could use the 10.*.*.* range, all 
from class A up. this range is reserved for uses with subnets. Somehow hoewever 
microsoft came with the idea of internet sharing, and using the 192.168.0.* range by 
default, which may be misleading.

sorry list for this unrelated subject, just saw it and it grabbed my mind for a second.

regards,

rene


 i make the user and system dsn, anyone have a good idea of fix my problem?
 
 
 thanks
 
 
 -
 otro correo: [EMAIL PROTECTED]
 
 
 
 
 ---
 Runbox Mail Manager - www.runbox.com
 Free online email application
 
 -
 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:Re: when i try connect since a client windows9x to mysql ...

2001-09-11 Thread Miguel Enriquez Alvarado 

  this is my first question:
  
  when i try connect since a client windows9x to mysql (in a server linux rh 7.0), 
say me the next error:

  General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL PROTECTED] (using 
password YES) alias Test
 
 You must grant user rights to mysql first.
 
 use mysql console (eventually on server itself):
 
 mysql -u root -p
 mysql GRANT ALL ON *.* TO 'myname'@'192.168.1.1' IDENTIFIED BY 'a_password';
 mysql flush privileges();

first: in the line:  flush privileges(); the correct statment is: flush privileges;

second: i try connect since my client win98 (i build an Delphi app), but say me the 
next error:

Key Violation [TCX][MyODBC] Access Deneied for user 'root'@'192.168.1.197' (using 
password YES) alias Test

NOTES: i have configured my user dsn:

Windows DSN name: test
MySQL Host (name or IP): 192.168.1.1
MySQL Databasename: firstdb
User: root
Password: 123456
Options checked's: don't Optimize column width and Return Matching rows

the system Dsn is same...

my server have the next adress: 192.168.1.1

thanks







---
Runbox Mail Manager - www.runbox.com
Free online email application

-
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

when i try connect since a client windows9x to mysql ...

2001-09-10 Thread Miguel Enriquez Alvarado 

hi all

this is my first question:

when i try connect since a client windows9x to mysql (in a server linux rh 7.0), say 
me the next error:
  
General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL PROTECTED] (using 
password YES) alias Test

i make the user and system dsn, anyone have a good idea of fix my problem?


thanks


-
otro correo: [EMAIL PROTECTED]




---
Runbox Mail Manager - www.runbox.com
Free online email application

-
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