seethru Posted January 15, 2004 Share Posted January 15, 2004 I've read the documentation, tried re-installing mysql many times and still I get ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES). I've ran it with --skip-grant-table and I can login that way, and I change the password that way, but once I try to run it normally I get that error again. Link to comment Share on other sites More sharing options...
jonovate Posted January 15, 2004 Share Posted January 15, 2004 What syntax do u use when u login? mysql -u root -p <enter pass> Link to comment Share on other sites More sharing options...
seethru Posted January 15, 2004 Author Share Posted January 15, 2004 thats the syntax yea and I also use mysql -u root -p<passwordhere> Link to comment Share on other sites More sharing options...
seethru Posted January 15, 2004 Author Share Posted January 15, 2004 anyone? I've run out of ideas. This is mysql 4.1alpha btw. However it did the exact same thing with 4.0.16. Link to comment Share on other sites More sharing options...
kemical Posted January 15, 2004 Share Posted January 15, 2004 did you actually run the mysqladmindb properly when setting the password? have you tried logging in without using a password? Link to comment Share on other sites More sharing options...
seethru Posted January 15, 2004 Author Share Posted January 15, 2004 yes I ran mysqladmin correctly, and it returned that I didn't have permission to change other peoples passwords......and I was using root in the shell and in mysql. Link to comment Share on other sites More sharing options...
seethru Posted January 15, 2004 Author Share Posted January 15, 2004 hrm, weird....lets me login when run normally, if I don't specify a password......but I can't access any databases. Link to comment Share on other sites More sharing options...
seethru Posted January 15, 2004 Author Share Posted January 15, 2004 well, a fourth re-install seems to have done the trick. Link to comment Share on other sites More sharing options...
Recommended Posts