Andy "It could be as a simple as:
mysql> create user 'your_username'@'%' identified by 'your_pass'; grant mysql> all on yourdb.* to 'your_user'@'%';" I'm not quite sure what you man by that as I am very new to MySql, could you elaborate a bit if you have the time. Cheers Stu -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Smith Sent: 21 December 2006 13:12 To: [email protected] Subject: Re: [Peterboro] MySql Server in a Windows Domain 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 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.26/594 - Release Date: 20/12/2006 15:54 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.26/594 - Release Date: 20/12/2006 15:54 _______________________________________________ Peterboro mailing list [email protected] https://mailman.lug.org.uk/mailman/listinfo/peterboro
