[BozemanLUG] MySQL Question

[Matt Griffith]

Were you logged in at root on the server (or try with sudo).

Matt

Mike Stone wrote:
> 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 
> <mailto: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 <mailto:Discuss at bozemanlug.org>
>     > http://lists.bozemanlug.org/mailman/listinfo/discuss
>     >
>
>     _______________________________________________
>     Discuss mailing list
>     Discuss at bozemanlug.org <mailto: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
>