I suspect your problem is nothing to do with mysqladmin but more to do
with mysql admin rights itself. Would suggest doing some command line
access to mysql with the username and password specified (and host if
you are not local) just to verify settings :
mysql -uUsername -pPassword -hHostname
Hostname may be removed if local, or if your privileges are screwed up
it is possible if you are connecting on the localbox that you may have
to specify -hlocalhost (or 127.0.0.1 or [but less likely] the external
IP address of your server)
Martin
On Fri, 2007-10-05 at 14:24 +0100, Richard Forth wrote:
> 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!"
>
> *****
> plain text document attachment (ATT874790.txt), "ATT874790.txt"
> _______________________________________________
> Peterboro mailing list
> [email protected]
> https://mailman.lug.org.uk/mailman/listinfo/peterboro
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
