Mysql access denied error when I try rake db:create

Question

I install mysql for RoR, and I get an access denied error. I've tried searching on the internet for how to go about fixing this ... but I have no clue on how to proceed right now.

Basically, I did this: sudo apt-get install mysql-client mysql-server libmysql-ruby1.8

And I did get the password screen. I am sure I picked a password I know, and yet I am getting the following error when I try to run rake db:create: Access denied for user 'root'@'localhost' (using password: YES)

How can I fix this? Thanks!

what is my hostname? my command line is this: parallels@ubuntu:~/Desktop$ — Ringo Blancke
– Ringo Blancke, Commented Mar 8, 2012 at 23:50

Jon · Accepted Answer · 2012-03-09 13:55:17Z

1

Try following the instructions for resetting the root password from the official MySQL documentation:

Read this - MySQL Root Password Reset Instructions

answered Mar 9, 2012 at 13:55

Jon

10.9k2 gold badges38 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

James Brooks · Accepted Answer · 2012-03-09 00:03:14Z

1

Are you able to connect to the database using

mysql -uroot -p -hlocalhost

or

mysql -uroot -p -h127.0.0.1

if your able to connect using the second but not the first, modify your database.yml file to include Host: 127.0.0.1 and remove the line with Socket.

answered Mar 9, 2012 at 0:03

James Brooks

6584 silver badges5 bronze badges

1 Comment

Ringo Blancke Over a year ago

both give me "access denied". I just need a way to reset this password somehow ... that's what is so frustrating.

Collectives™ on Stack Overflow

Mysql access denied error when I try rake db:create

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related