Connecting remote database server in Rails app failed

Question

Using Rails 3.2, mysql2 gem, MariaDB 5.5. I got the following error while trying to deploy the app for the first time:

Mysql2::Error: Access denied for user 'abc'@'%' to database 'app_production'

I'm not sure why the percent sign % in 'abc'@'%'.

Here's my database.yml:

production:
  adapter: mysql2
  encoding: utf8
  reconnect: true
  host: db.domain.com
  port: 3306
  database: app_production
  pool: 5
  username: abc
  password: some_password_here
  socket: /run/mysqld/mysqld.sock

My /etc/mysql/my.cnf has bind 0.0.0.0, firewall is temporarily disabled with sudo iptables -F.

% is a wildcard. There's more about this in MySQL Error 1045, “Access denied for user 'user'@'localhost' (using password: YES)”) and Allowing wildcard (%) access on MySQL db, getting error “access denied for '<user>'@'localhost'”. — Hew Wolff
– Hew Wolff, Commented Nov 29, 2014 at 18:12

Altmish-E-Azam · Accepted Answer · 2014-11-29 20:28:26Z

1

This error due to permission on database access for the user, so you have to grant access permission for this user on above database. Find below command to grant permission. run these command on mysql terminal

GRANT ALL PRIVILEGES ON app_production.* TO 'abc'@'%'  WITH GRANT OPTION
FLUSH PRIVILEGES

answered Nov 29, 2014 at 20:28

Altmish-E-Azam

1,5732 gold badges13 silver badges25 bronze badges

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

1 Comment

Victor Over a year ago

Thanks. I replace the wildcard % with ip_address instead.

Hew Wolff · Accepted Answer · 2014-11-29 18:08:22Z

-1

It sounds like the user abc is not set up with MySQL. Go to your MySQL client and make sure that user is created (with that database).

answered Nov 29, 2014 at 18:08

Hew Wolff

1,5098 silver badges17 bronze badges

Collectives™ on Stack Overflow

Connecting remote database server in Rails app failed

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related