TechTricks
Technical answers from the trenches 
 
 
 
 

     
   
MySQL: What does 'ERROR 1045: Access denied for user' mean?
 
   
 Posted: 23 January 2002
 
   
 
Audience: Beginner
 
       
   

Question: I'm trying to start the mysql command-line utility and keep getting 'ERROR 1045: Access denied for user.' What does this mean and how do I fix it?

Answer: There are a few possibilities; you:

1. Didn't tell mysql to prompt you for the password. Try starting it like this:

     mysql -u username -p

(Remember to replace "username" with the MySQL username assigned by your administrator.)

2. Supplied the wrong password. (Usernames and passwords are case-sensitive.)

3. Don't have access. Contact your administrator for more assistance.

Warning: While it's possible to specify your password while starting the mysql utility, we strongly recommend against doing so. If you do so, it's very possible your password can then be viewed by others using your system. Consider, for example, the w command, which (among other things) displays the command you're executing--along with any parameters used to start it.

 

       

Top

Feedback About Paradox Delphi Assorted Web Stuff
 
 
Copyright © 2000-2004, techtricks.com; All Rights Reserved.
Acknowledgements, Disclaimers, Terms and Conditions.
Article last updated on 31 May 2003

 

Other Sites: Paradox, Delphi, Perl, Web Stuff, and More


 

[- End -]