Correct MySQL configuration for Ruby on Rails Database.yml file

by

You should separate the host from the port number.
You could have something, like:

development:
  adapter: mysql2
  encoding: utf8
  database: my_db_name
  username: root
  password: my_password
  host: 127.0.0.1
  port: 3306

More Related Contents:

  1. Error installing mysql2: Failed to build gem native extension
  2. Rails, MySQL and Snow Leopard
  3. How to delete duplicate records in mysql database?
  4. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  5. What the difference between mysql and mysql2 gem
  6. Rails select random record
  7. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  8. mysql2 gem compiled for wrong mysql client library
  9. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  10. gem install: Failed to build gem native extension (can’t find header files)
  11. Rails 3 ActiveRecord: Order by count on association
  12. Use YAML with variables
  13. MySQL Install: ERROR: Failed to build gem native extension
  14. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  15. how to use DISTINCT ON with mysql using ActiveRecord
  16. libmysqlclient15-dev on macs?
  17. ld: library not found for -lzstd while bundle install for mysql2 gem Ruby on macOS Big Sur 11.4 Apple M1
  18. Ruby gem mysql2 install failing [duplicate]
  19. How do you write a case insensitive query for both MySQL and Postgres?
  20. How do I set up the database.yml file in Rails?
  21. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  22. Could not connect: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  23. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  24. database.yml &references not working
  25. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  26. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  27. How to send email from MySQL 5.1
  28. How to create relationships in MySQL
  29. Mysql Join Two tables on keys
  30. How do I use CSS with a ruby on rails application?

Leave a Comment