rs Posted September 11, 2006 Share Posted September 11, 2006 Just started mysql on HPUX server. Trying to use batch mode to create a table. I can't get past the ERROR 1044 and ERROR 1045 message. /tmp/sampdb>mysql -u sampadm -p < create_member.sql Enter password: ************************************************ERROR 1045 (28000): Access denied for user 'sampadm'@'localhost' (using password: YES) Quote Link to comment Share on other sites More sharing options...
fenway Posted September 11, 2006 Share Posted September 11, 2006 Can you login as root? Quote Link to comment Share on other sites More sharing options...
rs Posted September 11, 2006 Author Share Posted September 11, 2006 yes, I can use root Quote Link to comment Share on other sites More sharing options...
fenway Posted September 11, 2006 Share Posted September 11, 2006 Then it sounds like the user you specified doesn't have the right credentials. Quote Link to comment Share on other sites More sharing options...
rs Posted September 11, 2006 Author Share Posted September 11, 2006 Credentials? I did the "GRANT ALL" from root user. I am also using a user account for mysql instead of using root. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 11, 2006 Share Posted September 11, 2006 Make sure you don't have one of those localhost vs. 127.0.0.1 issues. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.