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