Richard Forth wrote:
Yep thats correct. Surely MySQLadmin has its own config file that is
saying to the system "hey, if they dont specify the logon details, try
these?"
As far as I was aware, the default values of "root" for user and "no
password" are hardcoded into the mysqladmin binary, and other MySQL
binaries like mysql, mysqldump, etc.
But a quick Google suggests that you can add to my.cnf
[client]
user=myuser
password=mypassword
or in your case
[client]
user=root
password=mysqlrootpassword
(add to the existing [client] section if it already exists rather than
creating one) .
Furthermore, if you put these settings in ~/.my.cnf (ie a file .my.cnf
in your home directory) the settings will be just applicable when you
log in. Note the leading dot in the filename.
I would guess that there is an equivalent way to do all this under
Windows if necessary. I think my.cnf becomes my.ini, and is probably in
the MySQL program directory somewhere.
--
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
