RoR and problem with connection to MySQL database

rubyonrails-talk
1

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.

2

Hello Manny

Use another user, not root

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

3

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.

4

Hi,

in mysql console

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

tom

5

Thanks Tom,

finally it works for me! :slight_smile: