Rails and Mysql2 Access denied for user 'root'@'localhost' (using password: NO)

Question

I am somewhat new to Rails, and much of my experience involves me feeling out how to work out the problem so I apologize in advance if I have missed and obvious solution. I run a Windows machine.

I am creating a log-in and registration using mysql2. MySQL installer has already been used to install the server, workbench, etc. (I configured the root password as password) and I have already installed the mysql2 gem.

The rails was bundled successfully but when I entered rake db:create, the error Access denied for user 'root'@'localhost' (using password: NO) occurred.

Rails then prompted me for my password, I entered it but the error occurred again. After entering my password the second time, it seemed as if it worked fine until I tried to do a rails db:migrate wherein the error appeared again making it not possible to migrate.

This confuses me because in the MySQL query, I have my password set as the same one I entered. I tried giving the 'root' user all the schema privileges, but that made no difference. Please tell me how to solve this problem and thank you.

If you have any questions about my question, please ask.

zombie_ghast · Accepted Answer · 2015-11-24 17:15:28Z

32

for me helped

$ mysql -u root -p

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypassword')

and in databse.yml

development:
adapter: mysql2
database: mydb
host: localhost
username: root
password: "mypassword" #I had an empty string here before

thanks to @spongezh22

answered Nov 24, 2015 at 17:15

zombie_ghast

1,78316 silver badges22 bronze badges

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

3 Comments

Franck Boudraa Over a year ago

Same problem if your password starts with the ! character.

TheVinspro Over a year ago

@zombie_ghast It doesn't work for me. It still asks a password when I run mysql -u root -p password is same as I set during installation. please help me to resolve this issue.

aaronkelton Over a year ago

Don't forget your semicolon for: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypassword');

Bharat soni · Accepted Answer · 2014-02-12 05:58:40Z

10

seems like your user cannot connect to the mysql DB, try this commands in your console

mysql -u root -p

and when prompted give the password as 'admin'

if this is possible then you should be good to go

And you database yml file should be like

development:
 adapter: mysql2
 database: mydb
 host: localhost
 username: root
 password: mypass

answered Feb 12, 2014 at 5:58

Bharat soni

2,79621 silver badges29 bronze badges

3 Comments

spongezh22 Over a year ago

Thanks, that seemed to of fixed the migration but now I changed the routes file to Login::Application.routes.draw do resources :users get '/register' root 'users#index' and when I did rails s , a large error occured

spongezh22 Over a year ago

The error is too large for the comment size but I tried reinstalling everything and when I created a fresh program with mysql and did rails s , the browser shows Mysql2::Error Access denied for user 'root'@'localhost' (using password: NO) Rails.root: C:/Sites/rails_projects/practice . I would assume I have missed doing something in the Mysql workbench but I am not sure what it could be. @Bharatsoni

spongezh22 Over a year ago

My Mysql workbench has the command SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypassword') if this information helps

Igorzovisk · Accepted Answer · 2018-09-19 19:01:19Z

2

Running ./bin/spring stop fixed for me. I found it in a Github, but can't remember where.

answered Sep 19, 2018 at 19:01

Igorzovisk

6748 silver badges21 bronze badges

Comments

macjeans · Accepted Answer · 2014-12-12 16:16:49Z

1

I just copied and pasted the above (below) to my rails yml file and it worked!!

development:
adapter: mysql2
database: mydb
host: localhost
username: root
password: mypass

answered Dec 12, 2014 at 16:16

macjeans

417 bronze badges

Comments

Michael Chemani · Accepted Answer · 2017-03-28 07:22:35Z

1

Rake try in fact to create your test database as well, that's why you get the error message if you do not set correctly your test database credentials like (database.yml)

default: &default
    adapter: mysql2
    encoding: utf8
    database: atheneum
    pool: 5
    username: ******
    password: "******"
    host: localhost


development:
  <<: *default
  database: atheneum

test:
  <<: *default
  database: atheneum_test

answered Mar 28, 2017 at 7:22

Michael Chemani

211 bronze badge

Comments

lennart · Accepted Answer · 2018-10-19 11:05:25Z

1

My problem was due to the password starting with "!". Changing my password in mysql and database.yml solved it for me.

answered Oct 19, 2018 at 11:05

lennart

1491 silver badge8 bronze badges

Comments

Willian Araujo · Accepted Answer · 2020-01-17 15:03:34Z

1

In my case, it was just an incorrect database password that was in the database.yml file. I changed the password and it worked perfectly.

answered Jan 17, 2020 at 15:03

Willian Araujo

211 bronze badge

Comments

user5099519 · Accepted Answer · 2018-02-05 14:19:16Z

0

This was one of the few occasions where I had to restart the rails server after I made changes to the database.yml file. After I set the password in the file, I had to restart the rails server. After that the error went away.

answered Feb 5, 2018 at 14:19

user5099519

Comments

Josiah · Accepted Answer · 2019-02-06 18:19:01Z

0

Not a rails answer, but for others showing up here:

If you are passing in your own credentials somehow, perhaps an ENV file to a standalone script, be sure that you don't have any invisible characters like a '\n' at the end of your password. That'll really mess with you.

answered Feb 6, 2019 at 18:19

Josiah

2,9166 gold badges33 silver badges42 bronze badges

Comments

A. Askarov · Accepted Answer · 2019-08-28 06:40:55Z

0

Error was saying that Access denied for user root. (I had no password). My problem was for the reason that i've changed the default 3306 port to 8111. In database.yml ive added port: 8111.

answered Aug 28, 2019 at 6:40

A. Askarov

7357 silver badges14 bronze badges

Comments

Rob Rouse Jr. · Accepted Answer · 2021-01-22 04:22:23Z

0

If you don't remember setting your password, do this:

sudo mysql -u root

use mysql;

UPDATE user set authentication_string='MyPassword' where user='root';

This will update your password. Then, change the database/config.yml file to match your password.

(Depending on the version of MySQL you're running, you might have to surround the 'password' with a PASSWORD() function or a sha2() function)

answered Jan 22, 2021 at 4:22

Rob Rouse Jr.

691 silver badge6 bronze badges

Comments

uberdave · Accepted Answer · 2019-04-05 06:01:27Z

-1

On advise of Bhrat above I created my linux user as a user in mysql. ensured that user can connect from $user changed user from root in database yml to user rake db:create worked

answered Apr 5, 2019 at 6:01

uberdave

5021 gold badge5 silver badges16 bronze badges

Collectives™ on Stack Overflow

Rails and Mysql2 Access denied for user 'root'@'localhost' (using password: NO)

12 Answers 12

3 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

12 Answers 12

3 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related