Knocked Out Before The Bell Rang
May 16, 2006 7:18 AM Subscribe
I'm encountering what I imagine is an entirely rudimentary SQL error, but am baffled as to how to solve it.
posted by boombot to Computers & Internet (80 answers total) 1 user marked this as a favorite
I've just installed MySQL 4.1.18-standard on my Mac (10.4.6) to work along with David Heinemeier Hansson's _Agile Web Development with Rails_. I'm absolutely new to MySQL and Ruby, and right out of the box (literally, like the fourth page after things really start getting instructive) I've encountered the following error after the command mysql -u root -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
During installation I never set a password. I've input 'admin', 'root' and other guesses in as the password - the error is always the same. If I provide a carriage return without entering anything, the error changes slightly:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I've found interesting stuff by searching, but some sources seem to contradict others, or take for granted an expertise I don't possess - I have absolutely no background in MySQL or the command line. I'm looking for absolutely thorough and remedial steps for remedying this problem.
Local delicacies happily mailed to the home of the kind soul that gets me through this.