check out the docs at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT
Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Tel: (632) 634-5141/ (632) 634-5140 Fax: (632) 634-5139 ----- Original Message ----- From: "Gerald R. Jensen" <[EMAIL PROTECTED]> To: "Luie delos Santos" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 19, 2002 10:21 PM Subject: Re: can login only as root > Luie: > > Here is a grant script we use ... check the syntax against the query you > were using: > > USE mysql; > > GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'userpwd'; > GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'userpwd'; > GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY > 'userpwd'; > GRANT RELOAD,PROCESS ON *.* TO username@localhost; > > Be careful ... the use created with this script has full access to all > databases on your server. > > Gerald Jensen > > ----- Original Message ----- > From: "Luie delos Santos" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, January 19, 2002 3:03 AM > Subject: can login only as root > > > hello all, > > I recently installed mysql on a RedHat7.2 box. I was able to login to it as > *root*. > I created another user (user1) using "GRANT all to user1 identified by > 'password';", but when I tried to login as *user1*, access denied message is > displayed. > I've tried *flush privileges* but I'm still unable to login as user1. > > hope somebody can shed some light on this. > thanks in advance... > > > luie > > __________________________________ > www.edsamail.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 > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
