Hi, haven't you added "identified by *****" int he grant statement. I don't see it in your show grants comand.
Mathias Selon Chris Faulkner <[EMAIL PROTECTED]>: > Hello > > I am trying to connect from host 192.168.0.8 on my home network to a > database on 192.168.0.7. When I connect as root on 192.168.0.7 itself, > I can do this > > mysql> show grants for 'root'@'192.168.0.8'; > +--------------------------------------------+ > | Grants for [EMAIL PROTECTED] | > +--------------------------------------------+ > | GRANT USAGE ON *.* TO 'root'@'192.168.0.8' | > +--------------------------------------------+ > 1 row in set (0.00 sec) > > However, when I try to connect from 192.168.0.8, I get an error (1045: > Access denied). What else do I have to do ? > > Thanks > > Chris > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
