try this one.
[allan@atlas allan]$ mysql -u root -p mysql
update user set Password=password('your_password') where User='your_user';
\q
[allan@atlas allan]$ mysqladmin -u root -p reload
[allan@atlas allan]$ mysqladmin -u <your_user> -p password <your-password>
On Thu, 5 Apr 2001, Edsel Mabilangan wrote:
>
> if you can access mysql just update your user account's password then exit
> mysql and then reload as root
>
> On Thu, 5 Apr 2001, Clemen Canaria wrote:
>
> > i got this error:
> >
> > mysqladmin: unable to change password; error: 'You are using MySQL as an
> > anonymous users and anonymous users are not allowed to change passwords'
> >
> >
> > ----- Original Message -----
> > From: "Allan T. Parreno" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, April 05, 2001 3:00 AM
> > Subject: Re: [plug] mysql password
> >
> >
> > >
> > > mysqladmin -u <user> password <new-password>
> > >
> > >
> > > On Thu, 5 Apr 2001, Clemen Canaria wrote:
> > >
> > > > how do i set my mysql password? tia.
> > > >
> > > > ---
> > > > Clemen Canaria
> > > > Web Developer, Interactive Media
> > > > [EMAIL PROTECTED]
> > > >
> > > > Global Sources (NASDAQ: GSOL)
> > > > Enabling global merchandise trade
> > > > www.globalsources.com
> > > >
> > > > 15/f Citibank Center, 8741 Paseo de Roxas, 1226 Makati City, Philippines
> > > > Tel: (632) 814-1413; Fax: (632) 892-4085
> > > >
> > > > _
> > > > Philippine Linux Users Group. Web site and archives at
> > http://plug.linux.org.ph
> > > > To leave: send "unsubscribe" in the body to
> > [EMAIL PROTECTED]
> > > >
> > > > To subscribe to the Linux Newbies' List: send "subscribe" in the body to
> > [EMAIL PROTECTED]
> > > >
> > >
> > > --
> > > - - - - - - - - - - - - - - -
> > > a l l a n t . p a r r e n o
> > > OneVirtual Internet Inc.
> > > ---
> > > Every moment is your oppurtunity to make use of your incredible good
> > > fortune. Life can indeed be great when you make up your mind to do
> > > something about it.
> > >
> > > _
> > > Philippine Linux Users Group. Web site and archives at
> > http://plug.linux.org.ph
> > > To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
> > >
> > > To subscribe to the Linux Newbies' List: send "subscribe" in the body to
> > [EMAIL PROTECTED]
> >
> > _
> > Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
> > To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
> >
> > To subscribe to the Linux Newbies' List: send "subscribe" in the body to
>[EMAIL PROTECTED]
> >
>
> _
> Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
> To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
>
> To subscribe to the Linux Newbies' List: send "subscribe" in the body to
>[EMAIL PROTECTED]
>
--
- - - - - - - - - - - - - - -
a l l a n t . p a r r e n o
OneVirtual Internet Inc.
---
Every moment is your oppurtunity to make use of your incredible good
fortune. Life can indeed be great when you make up your mind to do
something about it.
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
