Re: [cobalt-developers] Mysqladmin error

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"John D. Gorena" <Support@xxxxxxxxxxxxxxxxxxx> wrote:
> Steve,
>
> I assume that you know that I am a newbie and your help is appreciated.
With
> your hint, I figured it out and I am spelling it out here for other
Newbies.

I assumed you were new to MySQL; I made no other assumptions.

> What I did after installing the *.pkg from the GUI:
> According to http://pkg.nl.cobalt.com/howto/casp_mysql_howto.html (step
10), as
> directed from http://pkg.nl.cobalt.com/ , I did run the following command
with
> 'newbie' as my password for NEW-PASSWORD:  (in this example my password is
> 'newbie').
> The instructions said:
>     mysqladmin -uroot -pcobalt-mysql password NEW-PASSWORD
> So I typed
>     mysqladmin -uroot -pcobalt-mysql password newbie
>
> When creating a database name:
> The instructions from "mysqladmin --help" says that if the password is not
> supplied, then it will be asked.  This is not the case, therefore, Still
logged
> in as 'root' . . .

If you supply the '-p' flag without a password it will prompt you for it.
If you don't supply the flag it assumes there is no password.  FYI, there is
no connection b/w the server's user system and MySQL's privilege (user
access) system.  mysql, mysqladmin and the rest of the mysql commands can be
run by any user on the server as long as they supply a MySQL user/pwd combo
that's granted permission to do so in MySQL's grant tables.  See the manual
at www.mysql.com for details.

> I hope this helps the other newbies.

I'm sure it does.  I haven't used the package at pkg.nl.cobalt.com, but if
the instructions aren't clear to a newbie, then you may want to contact the
author and make some suggestions.

--
Steve Werby
President
Befriend Internet Services LLC
Tel: 804-355-WEBS
http://www.befriend.com/