RoR and problem with connection to MySQL database

Hello,

I am building my first application with MySQL database and I am solving
this problem - my app can't to connect to MySQL server.

MySQL server is running, in terminal (I am working at Mac) I created
MySQL table and I set password to MySQL with using following command:

mysqladmin -u root password 'mypass'

in database.yml is:

development:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: accounts
  pool: 5
  username: root
  password: mypass
  socket: /tmp/mysql.sock

And now I am trying my application, I am getting in browser error:

Mysql2::Error
Access denied for user 'root'@'localhost' (using password: YES)

I don't know what could be wrong -- the passwords are the same, I
thought is needed restart MySQL server -- so I did it, but still the
same error...

Could me someone help, please, where is fault? I am wondering about this
error whole afternoon, but without success...

Thanks a lot.

Hello Manny

Use another user, not root

Create a new user, for example, deploy, give permissions GRANT over the DB.

Hi Martin,

why is not possible to use the user "root"?

Could you please give me know, how to do the new user with grant
permission? (no experience with GRANT yet).
Thanks in advance.

Hi,

in mysql console

create database database_name;
grant all on database.* to username@localhost identified by 'password';
flush privileges;

tom

Thanks Tom,

finally it works for me! :slight_smile: