[BozemanLUG] MySQL Question

[Sheldon Ross]

sudo apt-get install postgresql-8.3

should fix it :)

> Date: Tue, 27 Jan 2009 23:20:10 -0700
> From: matt at griffdog.net
> To: discuss at bozemanlug.org
> Subject: Re: [BozemanLUG] MySQL Question
> 
> 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
> >   
> 
> _______________________________________________
> Discuss mailing list
> Discuss at bozemanlug.org
> http://lists.bozemanlug.org/mailman/listinfo/discuss

_________________________________________________________________
Windows Live™ Hotmail®…more than just e-mail. 
http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_howitworks_012009
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.bozemanlug.org/pipermail/discuss/attachments/20090128/f4310ab4/attachment-0001.html