Re: mysql refusing access from other machines
aaagh! i sure did miss that.
many thanks achim!
shannon
--- Achim Schmidt <schmidt@waaf.net> 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
> > dbuser@localhost 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
> > dbuser@192.168.1.2 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
Reply to: