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
