When I say I am a "newbie" I am not kidding. I have very little
knowledge on mysql syntax, keywords, and procedures. SO, please be
kind and clear if you choose to respond to this.

This is on a RedHat Enterprise Linux Advanced Server 4 Update 4 server
using mysql version 5.0.15. We have to use this version. No if,
ands, or buts.
I'm stuck with it.

I setup mysql version 5.0.15 with the standard rpm -ivh "blah blah"
and did this command
that I found:

/usr/bin/mysqladmin -r root flush-privileges password 18wheeler

And that was great. I could now enter mysql i.e. mysql -u root -p
and use the 18wheeler password.

Then someone said "NO" we need to change that password and standardize
it to something else.

So I began the search online for how to do that.

I tried to issue the same mysqladmin statement with a new password.
No luck.
Then somewhere it was said to use the mysqladmin -p option. Couldn't
get that to work.
Then I saw, use the mysqld_safe --skip-grant-tables. No luck.
Then I saw all sorts of stuff about "use mysql" and GRANT this and
that. No Luck.
Heck, I don't even know if these apply to version 5.0.15

Often the help I found was good, but was very unclear on what was a
KeyWord and what
was not. So I quessed at each and made some, probably bad,
assumptions. So I have password that I don't know what it is.

I thought I had it once, but then I was told to RELOAD privileges for
example, but I
never figured out how to get the --reload to work

Now I don't know where I am with mysql 5.0.15. I am just short of
doing an rpm -e and
getting rid of everything and starting over. But I know...according
to Murphy...that this
issue may arise again when I am in a position where I can't do an rpm -
e

Could someone please clearly walk me through what to do to just wipe
the password clean
and reset it? Please make Keywords vice User entered data plain plus
if and when to use
single quotes, double quoutes, parenthesis, etc. PLEASE?

Thanks to all you gurus who are probably shaking your heads. Just
remember, there was a time
when you first sat at a mysql prompt and said "Now What?"

On 16 May, 14:22, George <george.e.sulli...@saic.com> wrote:
> When I say I am a "newbie" I am not kidding. I have very little
> knowledge on mysql syntax, keywords, and procedures. SO, please be
> kind and clear if you choose to respond to this.
>
> This is on a RedHat Enterprise Linux Advanced Server 4 Update 4 server
> using mysql version 5.0.15. We have to use this version. No if,
> ands, or buts.
> I'm stuck with it.
>
> I setup mysql version 5.0.15 with the standard rpm -ivh "blah blah"
> and did this command
> that I found:
>
> /usr/bin/mysqladmin -r root flush-privileges password 18wheeler
>
> And that was great. I could now enter mysql i.e. mysql -u root -p
> and use the 18wheeler password.
>
> Then someone said "NO" we need to change that password and standardize
> it to something else.
>
> So I began the search online for how to do that.
>
> I tried to issue the same mysqladmin statement with a new password.
> No luck.
> Then somewhere it was said to use the mysqladmin -p option. Couldn't
> get that to work.
> Then I saw, use the mysqld_safe --skip-grant-tables. No luck.
> Then I saw all sorts of stuff about "use mysql" and GRANT this and
> that. No Luck.
> Heck, I don't even know if these apply to version 5.0.15
>
> Often the help I found was good, but was very unclear on what was a
> KeyWord and what
> was not. So I quessed at each and made some, probably bad,
> assumptions. So I have password that I don't know what it is.
>
> I thought I had it once, but then I was told to RELOAD privileges for
> example, but I
> never figured out how to get the --reload to work
>
> Now I don't know where I am with mysql 5.0.15. I am just short of
> doing an rpm -e and
> getting rid of everything and starting over. But I know...according
> to Murphy...that this
> issue may arise again when I am in a position where I can't do an rpm -
> e
>
> Could someone please clearly walk me through what to do to just wipe
> the password clean
> and reset it? Please make Keywords vice User entered data plain plus
> if and when to use
> single quotes, double quoutes, parenthesis, etc. PLEASE?
>
> Thanks to all you gurus who are probably shaking your heads. Just
> remember, there was a time
> when you first sat at a mysql prompt and said "Now What?"
What happened when you tried to follow the instructions in the mysql
manual?
http://dev.mysql.com/doc/refman/5.0/...rmissions-unix

On May 16, 10:31*am, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On 16 May, 14:22, George <george.e.sulli...@saic.com> wrote:
>
>
>
> > When I say I am a "newbie" *I am not kidding. *I have very little
> > knowledge on mysql syntax, keywords, and procedures. * SO, please be
> > kind and clear if you choose to respond to this.
>
> > This is on a RedHat Enterprise Linux Advanced Server 4 Update 4 server
> > using mysql version 5.0.15. *We have to use this version. *No if,
> > ands, or buts.
> > I'm stuck with it.
>
> > I setup mysql version 5.0.15 with the standard rpm -ivh "blah blah"
> > and did this command
> > that I found:
>
> > /usr/bin/mysqladmin -r root flush-privileges password 18wheeler
>
> > And that was great. *I could now enter mysql i.e. mysql -u root -p
> > and use the 18wheeler password.
>
> > Then someone said "NO" we need to change that password and standardize
> > it to something else.
>
> > So I began the search online for how to do that.
>
> > I tried to issue the same mysqladmin statement with a new password.
> > No luck.
> > Then somewhere it was said to use the mysqladmin -p option. *Couldn't
> > get that to work.
> > Then I saw, use the mysqld_safe --skip-grant-tables. *No luck.
> > Then I saw all sorts of stuff about "use mysql" and GRANT this and
> > that. *No Luck.
> > Heck, I don't even know if these apply to version 5.0.15
>
> > Often the help I found was good, but was very unclear on what was a
> > KeyWord and what
> > was not. *So I quessed at each and made some, probably bad,
> > assumptions. *So I have password that I don't know what it is.
>
> > I thought I had it once, but then I was told to RELOAD privileges for
> > example, but I
> > never figured out how to get the --reload to work
>
> > Now I don't know where I am with mysql 5.0.15. *I am just short of
> > doing an rpm -e and
> > getting rid of everything and starting over. *But I know...according
> > to Murphy...that this
> > issue may arise again when I am in a position where I can't do an rpm -
> > e
>
> > Could someone please clearly walk me through what to do to just wipe
> > the password clean
> > and reset it? *Please make Keywords vice User entered data plain plus
> > if and when to use
> > single quotes, double quoutes, parenthesis, etc. * *PLEASE?
>
> > Thanks to all you gurus who are probably shaking your heads. *Just
> > remember, there was a time
> > when you first sat at a mysql prompt and said "Now What?" *
>
> What happened when you tried to follow the instructions in the mysql
> manual?http://dev.mysql.com/doc/refman/5.0/...s.html#res...- Hide quoted text -
>
> - Show quoted text -

Hi Captain.

I get:

ERROR 1045 (28000): Access denied for user 'root@localhost' (using
password: YES)


I used the URL you provided. Thanks for that tip, I learned some more
stuff today which is
most always good.

On May 16, 11:10*am, George <george.e.sulli...@saic.com> wrote:
> On May 16, 10:31*am, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
>
>
>
>
> > On 16 May, 14:22, George <george.e.sulli...@saic.com> wrote:
>
> > > When I say I am a "newbie" *I am not kidding. *I have very little
> > > knowledge on mysql syntax, keywords, and procedures. * SO, please be
> > > kind and clear if you choose to respond to this.
>
> > > This is on a RedHat Enterprise Linux Advanced Server 4 Update 4 server
> > > using mysql version 5.0.15. *We have to use this version. *No if,
> > > ands, or buts.
> > > I'm stuck with it.
>
> > > I setup mysql version 5.0.15 with the standard rpm -ivh "blah blah"
> > > and did this command
> > > that I found:
>
> > > /usr/bin/mysqladmin -r root flush-privileges password 18wheeler
>
> > > And that was great. *I could now enter mysql i.e. mysql -u root -p
> > > and use the 18wheeler password.
>
> > > Then someone said "NO" we need to change that password and standardize
> > > it to something else.
>
> > > So I began the search online for how to do that.
>
> > > I tried to issue the same mysqladmin statement with a new password.
> > > No luck.
> > > Then somewhere it was said to use the mysqladmin -p option. *Couldn't
> > > get that to work.
> > > Then I saw, use the mysqld_safe --skip-grant-tables. *No luck.
> > > Then I saw all sorts of stuff about "use mysql" and GRANT this and
> > > that. *No Luck.
> > > Heck, I don't even know if these apply to version 5.0.15
>
> > > Often the help I found was good, but was very unclear on what was a
> > > KeyWord and what
> > > was not. *So I quessed at each and made some, probably bad,
> > > assumptions. *So I have password that I don't know what it is.
>
> > > I thought I had it once, but then I was told to RELOAD privileges for
> > > example, but I
> > > never figured out how to get the --reload to work
>
> > > Now I don't know where I am with mysql 5.0.15. *I am just short of
> > > doing an rpm -e and
> > > getting rid of everything and starting over. *But I know...according
> > > to Murphy...that this
> > > issue may arise again when I am in a position where I can't do an rpm -
> > > e
>
> > > Could someone please clearly walk me through what to do to just wipe
> > > the password clean
> > > and reset it? *Please make Keywords vice User entered data plain plus
> > > if and when to use
> > > single quotes, double quoutes, parenthesis, etc. * *PLEASE?
>
> > > Thanks to all you gurus who are probably shaking your heads. *Just
> > > remember, there was a time
> > > when you first sat at a mysql prompt and said "Now What?" *
>
> > What happened when you tried to follow the instructions in the mysql
> > manual?http://dev.mysql.com/doc/refman/5.0/...tml#res...Hide quoted text -
>
> > - Show quoted text -
>
> Hi Captain.
>
> I get:
>
> ERROR 1045 (28000): Access denied for user 'root@localhost' *(using
> password: YES)
>
> I used the URL you provided. *Thanks for that tip, I learned some more
> stuff today which is
> most always good.- Hide quoted text -
>
> - Show quoted text -

Hi again,
I just back from my favorite Indian Resturant so I could officially
stink up the office.
While there I was thinking about your post. So I came back, looked up
the URL again
and began to double check things. I realized, that when I had cut and
pasted the text to
print it out that I had not got ALL the text. At the bottom was more
info on using
the --skip-grant-tables syntax. Eureka....this worked.

Thanks Captain for commanding the ship with effective guidance.

On Fri, 16 May 2008 09:32:46 -0700 (PDT), George wrote:

> I just back from my favorite Indian Resturant so I could officially
> stink up the office. While there I was thinking about your post. So I
> came back, looked up the URL again and began to double check things. I
> realized, that when I had cut and pasted the text to print it out that
> I had not got ALL the text. At the bottom was more info on using the
> --skip-grant-tables syntax. Eureka....this worked.

So we now have a garlic fix to go with the strawberry query? (:

--
Is it just me, or is it a clear indication that a thread is ending its
useful life is when people start debating the merits of the analogies
that have been posed rather than the original subject matter of the
thread? --Rhetorical question by Rainer Atkins founding "Atkins' Law"

George wrote:
> On May 16, 11:10 am, George <george.e.sulli...@saic.com> wrote:
The bit that surprises me is that you said you searched online for help and
yet you hadn't even read the page in the manual that gave you the
instructions.
Instruction manuals are always my first port of call.