aaagh! i sure did miss that. many thanks achim!
shannon --- Achim Schmidt <[EMAIL PROTECTED]> wrote: > You are sure mysql is listening on all interfaces > and not only lo ? > > perhaps take a look to my.cnf and check if > "skip-networking" is active - > if yes simply comment it and restart mysqld. > > -achim > > Am Mo, 2004-08-02 um 11.47 schrieb Shannon R.: > > good day all! > > > > > > i'm getting really confused with how to properly > allow > > users to access mysql from other machines. (on > debian > > woody, using all stable packages) > > > > 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. > > > > im pretty sure i did this right, but it just wont > > work. did i do anything wrong? what could i > possible > > have overlooked? > > > > i even tried installing phpmyadmin and using it to > add > > users, even going as far as adding users with host > '%' > > but i just can't connect to mysql from another > > machine. > > > > anybody have any idea what could be going on here? > > > > > > thanks! > > shannon > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail is new and improved - Check it out! > > http://promotions.yahoo.com/new_mail > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
