[BozemanLUG] MySQL Question

[Mike Stone]

Trying that fails with this error:

'Access denied for user 'root'@'localhost' (using password: NO)'

Trying this:

mysqladmin --user=mysql password 'my_mysql_password'

I get this error:

'Access denied; you need the SUPER privilege for this operation'

Trying this:

mysqladmin --user=mysql

I get a big long help screen.  Starts with this:

mysqladmin  Ver 8.41 Distrib 5.0.67, for debian-linux-gnu on i486
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....
  -c, --count=#       Number of iterations to make. This works with -i
                      (--sleep) only.

Mike


On Tue, Jan 27, 2009 at 9:53 PM, Matt Griffith <matt at griffdog.net> wrote:

> Have you tried this from the command line?
>
> mysqladmin --user=root password 'my_root_password'
>
>
>
> Mike Stone wrote:
> > OK, I'm feeling pretty stupid here because I've done this before
> > several times, and never had an issue.  Now, all of a sudden, I can't
> > get things working.  Here's the story.
> >
> > I just built a brand new Ubuntu 8.10 LAMP server.  I'm going to be
> > hosting several websites from it, one of them being a Moodle site.
> > During the initial installation, it asks me for a MySQL user and
> > password.  I set that to "mysql" as the username and "notreally" as my
> > password (not really).  Installation finishes.  I download all the
> > updates currently available, and proceed to try to setup PHPMyAdmin.
> > I uncompress the directory, and create the web location.  I can't
> > login there using the "mysql" and "notreally" information.  At the
> > command line, and do a "sudo su" and then run mysql.  I get this error:
> >
> > Access denied for user 'root'@'localhost'
> >
> > OK, so I run "mysql -umysql -pnotreally".  I get this error:
> >
> > Access denied for user 'mysql'@'localhost'
> >
> > OK, so I run "mysql -umysql", and I'm into the mysql console.  Not
> > sure why, since I setup a password during the initial installation.
> > Wanting to fix this, I enter this command:
> >
> > set password for 'mysql'@'localhost' = PASSWORD('notreally');
> >
> > I get this error:
> >
> > Can't find any matching row in the user table
> >
> > I'm kind of at a loss now, since I logged in with that user, and it
> > worked.  Now I can't set a password?  So, thinking I'll fix it later,
> > I go to create my user and password for use with my PHPMyAdmin
> > installation.  Because of what that application does, it has to be a
> > superuser.  I enter these commands:
> >
> > create user phpmyadmin identified by 'againnotreally!';
> > grant all on *.* to 'phpmyadmin' identified by 'againnotreally!';
> > flush privileges;
> >
> > Or in all honesty, those are the commands that I was planning on
> > entering, but after the first one, I get this error:
> >
> > Access denied; you need the CREATE USER privilege for this operation
> >
> > At this point, I'm very confused.  I'm sure I've just missed something
> > easy, and I just need someone to say, "Hey stupid, you forgot this!"
> > Can anybody give me a hand on this?  I would really appreciate it.
> >
> > Mike
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Discuss mailing list
> > Discuss at bozemanlug.org
> > http://lists.bozemanlug.org/mailman/listinfo/discuss
> >
>
> _______________________________________________
> Discuss mailing list
> Discuss at bozemanlug.org
> http://lists.bozemanlug.org/mailman/listinfo/discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.bozemanlug.org/pipermail/discuss/attachments/20090127/b72dcdc3/attachment.html