"Shannon R." <[EMAIL PROTECTED]> wrote:
> 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. Check if your mysql server is ready to accept network connection. To check it, telnet to 192.168.1.2 port 3306 and see if MySQL answered. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]