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