Re: Wildcard and users...

2002-03-25 Thread dean browett 

Hi,

The command you need is: INSERT INTO USERS (Host,User,Password, 
privileges) VALUES ('%','Your_username', 'Your_passwd', privileges)

This will give you what you want.

Regards

Dean

At 22:12 24/03/2002 -0500, you wrote:
Hi,

I am wondering is there a way to set up user that can log in from anyplace?
I know I need to set this user up with the %(I hope this is the wildcard
for) mysql.

Thanks,

Chuck Payne


-
Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Dean Browett
Technical Development Manager
Push Information Systems : website design solutions
-- 
[EMAIL PROTECTED]
Tel: 01767 651466

This e-mail and any attached files are intended for the named addressee
only. It contains information which may be confidential and legally
privileged and also protected by copyright. Unless you are the named
addressee (or authorised to receive for the addressee) you may not copy
or use it, or disclose it to anyone else.

If you received it in error please notify the sender immediately and then
delete it from your system. We make every effort to keep our network
free from viruses. However you do need to check this e-mail and any
attachments to it for viruses as we can take no responsibility for any
computer virus which may be transferred by way of this e-mail.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Wildcard and users...

2002-03-25 Thread Egor Egorov 

Chuck,
Monday, March 25, 2002, 5:12:51 AM, you wrote:

CPP I am wondering is there a way to set up user that can log in from anyplace?
CPP I know I need to set this user up with the %(I hope this is the wildcard
CPP for) mysql. 

Yes, you are right. '%' is a wild card for any host in MySQL. How to
specify privileges for user look in the manual:
http://www.mysql.com/doc/G/R/GRANT.html
http://www.mysql.com/doc/P/r/Privileges.html

CPP Thanks,
CPP Chuck Payne





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Wildcard and users...

2002-03-24 Thread Chuck \PUP\ Payne 

Hi,

I am wondering is there a way to set up user that can log in from anyplace?
I know I need to set this user up with the %(I hope this is the wildcard
for) mysql. 

Thanks,

Chuck Payne


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php