Thanks Ed, I'm now a lot clearer. John Weller 01380 723235 07976 393631
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Ed Leafe > Sent: 10 December 2006 13:25 > To: [EMAIL PROTECTED] > Subject: Re: [NF] MySQL Queries > > > On Dec 9, 2006, at 11:03 AM, John Weller wrote: > > > Q1. When I add a user with MySQL Administrator there is a > > Resources tab for > > no of queries, etc with the values set to 0. Does 0 mean no > > queries or > > unlimited queries? There doesn't seem to be any mention in the > > help file. > > Setting to zero means 'no limit'. > > > Q2. At the moment I have MySQL installed on my dev machine so that any > > network issues are removed. I have one user, apart from 'root', > > 'john'@'localhost'. If I subsequently remove that installation and > > install > > it on a server with a machine name of 'dataserver' and connect to > > it from a > > workstation called 'work1' would I need two users, > > 'john'@'localhost' to > > access the data directly from the server and 'john'@'work1' to > > access from > > the workstation? > > Yes, or you could use "[EMAIL PROTECTED]" to mean user 'john' from any > non- > local host. > > > Q3. Does % in a user name, as in 'john'@'%', imply the wildcard? > > In other > > words if I say DROP USER 'john'@'%' would all users with the name > > john be > > dropped so, in the example above, 'john'@'work1' and > > 'john'@'localhost' > > would be dropped? > > Not quite. The '%' is a wildcard, but it means all *network* host > addresses. 'localhost' is not considered a network address. > > Most sites set up a root-like user that is only accessible from > localhost; this way, the only way to get that level of access is by > physically accessing the machine, or by ssh-tunneling into it. > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
