can login only as root

2002-01-19 Thread Victoria Reznichenko
Hello Luie, Saturday, January 19, 2002, 11:03:23 AM, you wrote: LdS> REALFROM: "Luie delos Santos" <[EMAIL PROTECTED]> LdS> HOUR: 2002011911 LdS> hello all, LdS> I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. LdS> I created another user (user1) using "GR

Re: can login only as root

2002-01-19 Thread Sherwin Ang
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

Re: can login only as root

2002-01-19 Thread Gerald R. Jensen
; <[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 b

can login only as root

2002-01-19 Thread Luie delos Santos
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 st