How do I access my mysql database in Rails?

Question

Say I have a database.yml that looks like this:

# SQLite version 3.x
#   gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
  adapter: mysql2
  database: arthouse_development
  username: root
  password:
  host: localhost
  port: 3306
  #socket: /tmp/mysql.sock

If this were postgres, all I need to do is type psql arthouse_development. What do I need to do here?

Also, it seems I have to type this everytime:

mysql -u root to just access mysql. Why is this? Can I configure this so that I don't have to do this everytime?

Буянбат Чойжилсүрэн · Accepted Answer · 2017-11-03 07:57:41Z

1

You can save this line as shell script.

mysql -uroot -ppassword arthouse_development

answered Nov 3, 2017 at 7:57

Буянбат Чойжилсүрэн

5614 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

How do I access my mysql database in Rails?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related