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

[Technical Director]

Positive Negative,

You might seriously consider not using 'root at localhost' as well 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.

Possibly making the username/password somewhat cryptic, say writing a
function to "dizzify" the usually clear text or at least setting up a
specific user/pass combination for specific databases is a very good idea.

eg:

$S_userName=__callDizzyFunc();
$S_passInfo=__callDizzyFunc();

At least this is SOMEWHAT more protective then:

$S_userName='root';
$S_passInfo='password';

2 cents.

Rob.

On Wed, 2 Feb 2005, Positive Negative wrote:

> Warning: Access denied for user 'root'@'localhost' (using password:
> NO) in /usr/local/www/sites/bender69/webcal/includes/php-dbi.php on
> line 48
> Error connecting to database:
>
>     Access denied for user 'root'@'localhost' (using password: NO)
>
>
> ----
>
> OK, how do i change it back.
>
> /usr/local/bin/mysqladmin -u root password
>
> This is where it got messed up....
>
> how do i fix it?
>
>
> --
>  AIM: FucPsSht
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
>