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]