MYSQL DATABASE YML FILE

When we create new app or we want to use mysql database then sometimes we forgot the mysql database.yml file setting:-

You can use this :-

gem 'mysql'

database.yml

   default: &default
      adapter: mysql2
      encoding: utf8
      pool: 5
      username: root
      password:
      socket: /opt/lampp/var/mysql/mysql.sock

  development:
      <<: *default
      database: database_name

  test:
      <<: *default
      database: database_name

  production:
      <<: *default
      database:  database_name

Comments

Popular posts from this blog

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

CARRIERWAVE - UPLOAD ANY MEDIA (AUDIO , VIDEO AND IMAGE ) FILE IN RAILS

SELECT COUNTRY WITH STATE AND IT'S CITIES RAILS

RAILS: UPLOADING PHOTOS VIA AMAZON S3 AND PAPERCLIP (UPLOADING FILES TO S3 IN RUBY WITH PAPERCLIP)

SEARCHING USING AJAX IN RAILS

UPLOAD ANY MEDIA FILE IN RAILS USING PAPERCLIP

UNINITIALIZED CONSTANT PAPERCLIP::STORAGE::S3::AWS

CURL COMMAND ON RUBY ON RAILS

CHECK PASSENGER RUBY PATH