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
