On Thu, Dec 21, 2006 at 01:00:43PM -0000, Stuart Bird wrote: > I am using a specific windows app to access the database however I > cannot get it to connect to the mysql-server at 192.168.10.222 or at > mysql-server. I get some sort of "this machine is not allowed to > access that server" kind of error message.
Youn will need to add a mysql user to the mysql server that has access from the IP(s) you are wishing to connect from, and privileges to do what it needs to do. You can use the host "%" to mean "from everywhere". It could be as a simple as: mysql> create user 'your_username'@'%' identified by 'your_pass'; mysql> grant all on yourdb.* to 'your_user'@'%'; Cheers, Andy -- http://strugglers.net/wiki/Xen_hosting -- A Xen VPS hosting hobby Encrypted mail welcome - keyid 0x604DE5DB
signature.asc
Description: Digital signature
_______________________________________________ Peterboro mailing list [email protected] https://mailman.lug.org.uk/mailman/listinfo/peterboro
