Re: [cobalt-developers] Mysqladmin error

["John D. Gorena" <Support@xxxxxxxxxxxxxxxxxxx>]

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.

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' . . .
to create is to use the password in the command.  :
                mysqladmin -pnewbie create myjunklist

I hope this helps the other newbies.

--
John D. Gorena
PC and Internet Marketing Consultant
http://www.JMG-Enterprises.com
Office: 972-315-0496
Fax: 972-315-3104



Steve Werby wrote:

> "John D. Gorena" <Support@xxxxxxxxxxxxxxxxxxx> wrote:
> > I installed the
> http://pkg.nl.cobalt.com/i386/RaQ3-RaQ4-MySQL-3.23.36-1.pkg
> > and even changed the password and all seemed to work OK.  But when I try
> to
> > create a list called 'mylist' (or any other name) I get the error that you
> see
> > below.
> >
> > [root@ns1 mysql]# mysqladmin create mylist
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> > [root@ns1 mysql]#
> >
> > What am I doing wrong?
>
> I think you answered the question yourself.  You changed the password for
> the mysql root user, but you didn't supply one for the mysqladmin command.
> Read about -p and -u flags by doing 'mysqladmin --help'.
>
> --
> Steve Werby
> President, Befriend Internet Services LLC
> http://www.befriend.com/
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers