Thanks for this info, has really helped me to understand how it all hangs together, sorry for being a bit thick, we went round the houses a bit. But that I think was my attempt at explaining myself.
I am not in front of my Linux machine right now but i will certainly give this a shot and let you all know the outcome. Thanks for your patience. And for all the responses. and for being thick...and.... :-) Regards Richard On 05/10/2007, Mark Rogers <[EMAIL PROTECTED]> wrote: > > 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 > -- ***** 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
