> 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:
The MySQL server IP address is 192.168.1.1 (see below) > > 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? What is the subnetmask? I assume 255.255.0.0 > > 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? > Above in this email you stated that the MySQL server's IP was 192.168.1.1 not 192.168.0.1 HTH, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]