Hi
I am working you RHEL4.4AS and new to mysql. i am getting mysql prompt
just by typing mysql at hash prompt. i.e.,

#mysql

mysql>

I tried to enter into mysql server with the following command.

#mysql -u root -p

and gave the system root password, but it did not accept it.

I tried to change the password in mysql prompt after entering into
mysql as step 1 above

mysql>UPDATE root SET PASSWORD = PASSWORD("newpassword");

but it did not change. Kindly help me.

In article 
<2dfcda15-e496-403d-ba7b-f701709a5cfd@h37g2000pro.googlegroups.com>,
 nag <visitnag@gmail.com> wrote:

> Hi
> I am working you RHEL4.4AS and new to mysql. i am getting mysql prompt
> just by typing mysql at hash prompt. i.e.,
> 
> #mysql
> 
> mysql>
> 
> I tried to enter into mysql server with the following command.
> 
> #mysql -u root -p
> 
> and gave the system root password, but it did not accept it.
> 
> I tried to change the password in mysql prompt after entering into
> mysql as step 1 above
> 
> mysql>UPDATE root SET PASSWORD = PASSWORD("newpassword");
> 
> but it did not change. Kindly help me.

Read the man page on mysqladmin.  That's how you administer the root 
user on MySQL.  Note it's different from the root user in UNIX.

-- 
DeeDee, don't press that button!  DeeDee!  NO!  Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]

On Aug 22, 8:09=A0am, Michael Vilain <vil...@NOspamcop.net> wrote:
> In article
> <2dfcda15-e496-403d-ba7b-f701709a5...@h37g2000pro.googlegroups.com>,
>
>
>
>
>
> =A0nag <visit...@gmail.com> wrote:
> > Hi
> > I am working you RHEL4.4AS and new to mysql. i am getting mysql prompt
> > just by typing mysql at hash prompt. i.e.,
>
> > #mysql
>
> > mysql>
>
> > I tried to enter into mysql server with the following command.
>
> > #mysql -u root -p
>
> > and gave the system root password, but it did not accept it.
>
> > I tried to change the password in mysql prompt after entering into
> > mysql as step 1 above
>
> > mysql>UPDATE root SET PASSWORD =3D PASSWORD("newpassword");
>
> > but it did not change. Kindly help me.
>
> Read the man page on mysqladmin. =A0That's how you administer the root
> user on MySQL. =A0Note it's different from the root user in UNIX.
>
> --
> DeeDee, don't press that button! =A0DeeDee! =A0NO! =A0Dee...
> [I filter all Goggle Groups posts, so any reply may be automatically igno=
red]

Thank you. I got the answer.