Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 2 Feb 2005 21:15:22 -0700 (MST)
From:      Technical Director <technical@ultratrends.com>
To:        Positive Negative <positiveviolence@gmail.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Access denied for user 'root'@'localhost' (using password: NO)
Message-ID:  <20050202211111.D64563@server1.ultratrends.com>
In-Reply-To: <3ce33c85050202184176ca49ac@mail.gmail.com>
References:  <3ce33c85050202184176ca49ac@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help

Positive Negative,

You might seriously consider not using 'root@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@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
>



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050202211111.D64563>