Access denied for user 'root'@'localhost' (using password: NO)

[Ted Mittelstaedt]

> -----Original Message-----
> From: owner-freebsd-questions at freebsd.org
> [mailto:owner-freebsd-questions at freebsd.org]On Behalf Of Technical
> Director
> Sent: Wednesday, February 02, 2005 8:15 PM
> To: Positive Negative
> Cc: freebsd-questions at freebsd.org
> Subject: Re: Access denied for user 'root'@'localhost' (using password:
> NO)
>
>
>
> Positive Negative,
>
> You might seriously consider not using 'root at localhost' as
> well

I would bet 10 to 1 that he's installing an application that already
is designed NOT to use the mysql root user to access it's database.
This is a case of someone who isn't understanding the design of
the app he's setting up.  It worked only because he was running an
out-of-box sql server install which had nothing for a root password.
He probably misread the instructions and used root instead of the
username that he was supposed to use.

> since most
> php scripts read the username/password information in clear text on a
> nobody:nobody read filesystem. IOW other people can read your files.
>

Do you run php database driven apps on the same server as you use to
provide shell services?  I don't.  If the webserver is configured
right it won't allow remote clients to read the scripts, only execute
them.

Ted