Yes, that is correct that those options are available on mysqladmin, I was going for a more fundamental approach initially to simply test access privileges rather than muddy the issue with trying to create a db - although it's a well screwed up mysql install that doesn't allow root to do this
On Fri, 2007-10-05 at 15:36 +0100, Mark Rogers wrote: > Richard Forth wrote: > > No i dont think you are understanding the question, > > You might have been right there :-) > > Martin's comments will get you most of the way but: > > > *mysqladmin create joomla-test* > > mysqladmin: connect to server at 'localhost' failed > > error: 'Access denied for user 'root'@'localhost' (using password: > NO)' > > mysqladmin also takes user and password parameters so > mysqladmin -uroot -p<password> create joomla-test > or > mysqladmin -uroot -p create joomla-test > > I'd recommend the latter if you care about security (the password is > harder for someone else on the server to detect, and it doesn't get > stored in your history etc). It simply asks you for your password, > they > key is that you've told it there is one. > > Given your error suggests you're using user "root" without a password > already, you should be able to ditch the "-uroot" bit as it already > knows that bit. > > -- > 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 > > > _______________________________________________ Peterboro mailing list [email protected] https://mailman.lug.org.uk/mailman/listinfo/peterboro
