[Gllug] MYSQL ... a permissions problem? mysql newbie installer warning...

[Ben Fitzgerald]

On Mon, Jan 02, 2006 at 07:27:00PM +0000, Ben Fitzgerald wrote:
> On Mon, Jan 02, 2006 at 07:02:40PM +0000, M.Blackmore wrote:
> > I've been setting up a server following a howto cookbook, including in
> > one of these mysql. This is on Suse 9.3 and a 400mhz/256mb old pentium
> > box, which is more than needed for the task I suspect!
> > 
> > After following the cookbook and apt getting (rather than YAST rpm'ing)
> > all the required files (as specified) I enter the command to set the
> > password (again as cookbook specified).
> > 
> > mysqladmin -u root password <mypasswordofchoice>
> > 
> > Then I get this thrown back at me:
> > 
> >  'Access denied for user 'root'@'localhost' (using password: NO)'
> > 
> > Yes, I am logged as root.
> > 
> > Sorry, some real basics are needed here - where do I go to change
> > anything in a config, if its a permissions file write problem, which one
> > do I change to allow?
> > 
> > As I said, total luser/noob with regards to mysql.
> 
> I think you have seen the mysqladmin help output and looked at the wrong
> "password".
> 
> The first is to authenticate you as -u <user> to perform an action:
> 
>  -p, --password[=name] 
>                       Password to use when connecting to server. If password is
>                       not given it's asked from the tty. WARNING: Providing a
>                       password on command line is insecure as it is visible
>                       through /proc to anyone for a short time.
> 
> The second is an action to change the password.

No idea how I missed this line out. This is the second mention of
"password":

  password new-password Change old password to new-password

> From your post I believe you have been using the latter when you wanted
> the former.

Too many mince pies. ;-)

Ben.

-- 
Registered Linux user number 339435
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug