[BozemanLUG] MySQL Question

[Rusty Conover]

Did you check your resolution of the "localhost" host name in /etc/ 
hosts or where ever resolv.conf is pointing?  I think mysql can get  
tripped up if it doesn't seem quite right.  It's been so long I forget  
all of the intricacies of mysql's security model, I just know it was a  
PITA since the config for access is inside the db compared to  
pg_hba.conf for postgres.

Rusty

On Jan 27, 2009, at 11:00 PM, 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>  
> 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
>
> _______________________________________________
> Discuss mailing list
> Discuss at bozemanlug.org
> http://lists.bozemanlug.org/mailman/listinfo/discuss

--
Rusty Conover
rconover at infogears.com
InfoGears Inc / GearBuyer.com / FootwearBuyer.com
http://www.infogears.com
http://www.gearbuyer.com
http://www.footwearbuyer.com







-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.bozemanlug.org/pipermail/discuss/attachments/20090127/d0073141/attachment.html