Hi
No i dont think you are understanding the question, PHPMyAdmin is not on my
Linux Box, im just saying that to fix that error on my wiondows box I
editted the phpmyadmin config file lines:
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication
method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password
(only needed
// with 'config'
auth_type)
to
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication
method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'mypassword'; // MySQL
password (only needed
// with 'config' auth_type)
But now, on my linux box, i changed the default password from blank to
{whatever}, and it seems that the command:
mysqladmin create [database]
is reading the default password from some config file instead of prompting
for a password (remember this command worked fine untill i changed the MySQL
password from the default blank to "something-other-than-blank").
There must be a config file for MySQLAdmin that the command is reading from
and generating the error (in red) I get below:
*mysqladmin create joomla-test*
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Remember this has nothing to do with PHPMyadmin *other than the error is
similar* - which i resolved on the windows box by editting a config file,
but PHPmyadmin is not even installed on the linux box. I'm just saying the
error was pretty similar, therefore there must be a config file for
SQLMYADMIN but I havent got a clue where to start looking. That way i can
just change the password in whatever config file it is for MySQLAdmin so
that it just works again or prompts me for a password each time.
Does that make more sense?
Cheers
Richard
On 05/10/2007, Mark Rogers <[EMAIL PROTECTED]> wrote:
>
> Richard Forth wrote:
> > Anyone got any ideas where i need to look?
>
> I would guess /var/www/phpmyadmin or similar.
>
> The file you're looking for is (from memory) config.inc.php in the
> document root (ie that directory I just mentioned if I got it right).
> Else try "locate config.inc.php"
>
> --
> Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555
> Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG
>
>
> _______________________________________________
> Peterboro mailing list
> [email protected]
> https://mailman.lug.org.uk/mailman/listinfo/peterboro
>
--
*****
Richard Forth
"I used to be indecisive, but now, I''m not so sure!"
*****
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
