[BozemanLUG] MySQL Question

[Mike Stone]

Thanks to everybody for their help, I really do appreciate it.  The solution
for me in this case was this:

/etc/init.d/mysql stop
mysqld --skip-grant-tables --skip-networking &
mysql mysql -u root
UPDATE user SET password=PASSWORD('notreally') WHERE user="root";
FLUSH PRIVILEGES;
/etc/init.d/mysql restart

It allowed me to set a password for an authenticated user, and it all was
downhill from there.

Mike


On Tue, Jan 27, 2009 at 10:36 PM, Sheldon Ross <ross_sheldon at hotmail.com>wrote:

>  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(R)…more than just e-mail. See how it works.<http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_howitworks_012009>
>
> _______________________________________________
> 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/8a7acb25/attachment-0001.html