Incidentally, the user/password that you login with is (and excuse me if I'm teaching grandma how to suck eggs) stored within mysql itself & doesn't lurk in some user accessible file some where.
If you manage to get a connection and have sufficient privileges you will find the information stored under a db called "mysql" with privileges handled by a combination of : user and other tables within that db. These tables can be updated directly bypassing the typical privilege commands but this is not for the feint hearted - or those not prepared for bizarre results if liberal use of the "flush privileges" is not used Anyway I'll go and do some work now Martin 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
