Hi, This definately works, not the most secure option I know but its only for playing with Joomla on my laptop in my spare time. If this was a live implementation I'd have left it out and just quoted the password on the commandline (then cleared command history).
adding the new section: [client] user=root password=mysqlrootpassword ..,stops the error when not specifying a userid and password for the command (for example): mysqladmin create joomla-test Mark your explanation helped me understand the logic, I did not realise the root/blank combination was hardcoded into the binary but that does make sense and explains why I could not find anything in the config files initially... Thanks everyone for your input. Regards Richard On 05/10/2007, Richard Forth <[EMAIL PROTECTED]> wrote: 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!" > > ***** > -- ***** 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
