I agree, connecting as root isn't the best way to do things.
grant all on *.* to u...@host identified by 'password';
than use that user to connect.
almost the same thing, I suppose - might want to do a better grant..
--Will
On Fri, Apr 24, 2009 at 12:54 PM, Doran L. Barton <f...@iodynamics.com>wrote:
> On Friday 24 April 2009 12:48:53 William Attwood wrote:
> > Sometimes the encryption messes up in MySQL.
> > head to your mysql.users table:
> > select user, password, host from mysql.users;
> >
> > than
> >
> > select md5('#helloworld3') from dual;
> >
> > see if the 2 outputs for "root" are the same.
>
> This whole connecting-to-your-database-as-root business always makes me
> skittish. PostgreSQL FTW!
>
> Incidentally, Linux Magazine is pushing a "Given the shaky outlook for
> MySQL,
> consider PostgreSQL" article today:
>
> < http://www.linux-mag.com/id/7306/1/ >
>
> "Looking for a mature, open source database that’s not owned by Oracle?
> Whether you’re already a fan or are looking for alternatives, now might be
> a
> good time to take a look PostgreSQL. The latest release of Postgres has a
> slew
> of built-in features that allow you to improve both performance and systems
> administration. Learn how you take advantage of them. "
>
> --
> Doran L. "Fozz" Barton <f...@iodynamics.com>
> Open-source developer, sysadmin, consultant, and all-around geeky dude
> "Drunk gets nine months in violin case"
> -- Headline seen in newspaper
>
>
> /*
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
> */
>
--
Warm regards,
William Attwood
Idea Extraordinaire
wattw...@gmail.com
Will Rogers <http://www.brainyquote.com/quotes/authors/w/will_rogers.html>
- "I don't make jokes. I just watch the government and report the
facts."
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/
