Re: lost root password trouble

[James Carrier]

Try

GRANT ALL PRIVILEGES ON *.* TO root@'%'
IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

Or you could always do a straight

INSERT INTO user VALUES('%','root',password('mypassword'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

james

---
Nick Wilson wrote:

Well, I'm in !! Now I'm having trouble updating the user table :-(

GRANT ALL PRIVILEGES ON * TO root IDENTIFIED BY 'my_password';

Read the manual, read my book, still a clueless twat. Can anyone help me
get it right?

many thanks everyone :-)


sql,query