good day all!
i'm getting really confused with how to properly allow
users to access mysql from other machines.
that is, i tried this as mysql root user:
GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'password';
after this, i can access mysql as 'dbuser' from the
localhost. the mysql servers ip add by the way is
192.168.1.1, and since i also want that user to be
able to access from 192.168.1.2, i also did this
command:
GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'password';
that should have been it but whenever i try to access
mysql from 192.168.1.2, i keep getting an "Can't
connect to MySQL server" error.
did i do anything wrong? that's what the documentation
said and i just followed it.
also, what if i also want to allow mysql access from
192.168.1.3? but not with the rest of the addresses on
192.168.0.0? how do i do that?
and there's yet another thing which confused me. if i
do 'mysql -u root -p' from the mysql server itself, i
can connect to it, but if i do 'mysql -u root -p -h
192.168.0.1', or just pointing to itself, i get the
same 'cant connect to mysql' error. anyone can shed
any light on why is this so?
thanks!
shannon
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
