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) Link to comment https://forums.phpfreaks.com/topic/20413-mysql-batch-mode-access-denied-on-hpux/ Share on other sites More sharing options...
fenway Posted September 11, 2006 Share Posted September 11, 2006 Can you login as root? Link to comment https://forums.phpfreaks.com/topic/20413-mysql-batch-mode-access-denied-on-hpux/#findComment-89940 Share on other sites More sharing options...
rs Posted September 11, 2006 Author Share Posted September 11, 2006 yes, I can use root Link to comment https://forums.phpfreaks.com/topic/20413-mysql-batch-mode-access-denied-on-hpux/#findComment-89945 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. Link to comment https://forums.phpfreaks.com/topic/20413-mysql-batch-mode-access-denied-on-hpux/#findComment-89997 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. Link to comment https://forums.phpfreaks.com/topic/20413-mysql-batch-mode-access-denied-on-hpux/#findComment-90016 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. Link to comment https://forums.phpfreaks.com/topic/20413-mysql-batch-mode-access-denied-on-hpux/#findComment-90021 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.