Jump to content


Photo

mysql batch mode access denied on hpux


  • Please log in to reply
5 replies to this topic

#1 rs

rs
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 11 September 2006 - 06:52 PM

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)

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 11 September 2006 - 07:27 PM

Can you login as root?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 rs

rs
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 11 September 2006 - 07:34 PM

yes, I can use root

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 11 September 2006 - 08:33 PM

Then it sounds like the user you specified doesn't have the right credentials.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 rs

rs
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 11 September 2006 - 09:03 PM

Credentials?  I did the "GRANT ALL" from root user.  I am also using a user account for mysql instead of using root.   

#6 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 11 September 2006 - 09:13 PM

Make sure you don't have one of those localhost vs. 127.0.0.1 issues.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users