If I read the thread correctly, it originally worked, then the password was changed (deliberately) but although the OP had worked out how to make phpMyAdmin work with the new password, he hadn't worked out how to get mysqladmin to play nicely, now that root's password had been changed (or more accurately now that root's password had been set).
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?" On 05/10/2007, Mark Rogers <[EMAIL PROTECTED]> wrote: > Martin Nix wrote: > > 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 > > > > If I read the thread correctly, it originally worked, then the password > was changed (deliberately) but although the OP had worked out how to > make phpMyAdmin work with the new password, he hadn't worked out how to > get mysqladmin to play nicely, now that root's password had been changed > (or more accurately now that root's password had been set). > > Changing permissions directly in the mysql database is rarely necessary > but not hard to do when needed (like you mention, "flush privileges" is > the main thing to be aware of. It can be useful for mass changes (eg > change passwords for several users across multiple domains). Another > thing worth knowing is that you can start MySQL telling it to ignore all > the permissions (--skip-grant-tables from memory), which then allows you > in with any user/pass to set the password again when you've forgotten > it. Of-course you need root privileges to start MySQL that way, but if > you don't have a password for root access then you have bigger problems > already :-) > > -- > 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
