<\/p>\n
Ruby on rails uses sqlite3 as a default database which is good for small application. If your project size is big, i.e. you need to handle large data throughout your project then\u00a0MySQL database is a better option.<\/p>\n
If your machine already has a MySQL, then there is no\u00a0need to install it again. In case, if MySQL is not present in your local machine, you can install it through the following procedure:<\/p>\n
Command for installing MySQL:<\/strong><\/p>\n If you have MySQL already, please skip the above 4 points.<\/strong><\/p>\n Now, open the terminal and type open the database.yml You will see the below code in your editor<\/p>\n # MySQL. Versions 5.1.10 and up are supported. # As with config\/secrets.yml, you never want to store sensitive information, <\/p>\n Change the username and password and save the database.yml file.<\/p>\n Run Open your phpmyadmin, you can see the database which is newly created.<\/p>\n","protected":false},"excerpt":{"rendered":" Ruby on rails uses sqlite3 as a default database which is good for small application. If your project size is big, i.e. you need to handle large data throughout your project then\u00a0MySQL database is a better option. If your machine already has a MySQL, then there is no\u00a0need to install it again. In case, […]<\/p>\n","protected":false},"author":20,"featured_media":889,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[12,19,5],"tags":[41,63],"yoast_head":"\n\n
\nsudo apt-get update<\/li>\n
\nsudo apt-get install mysql-server mysql-client libmysqlclient-dev*** Note: Durring installation, your local machine may ask the password for the root user<\/li>\n
\nsudo mysql_install_db
\nsudo mysql_secure_installation<\/li>\n
\ngem install mysql2<\/li>\n<\/ol>\n
\n> rails new app -d mysql
\nrails setup is created in your local machine
\n> cd app<\/p>\n
\n> nano config\/database.yml<\/p>\n
\n#
\n# Install the MySQL driver
\n# gem install mysql2
\n#
\n# Ensure the MySQL gem is defined in your Gemfile
\n# gem ‘mysql2’
\n#
\n# And be sure to use new-style password hashing:
\n# https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/password-hashing.html
\n#
\ndefault: &default
\nadapter: mysql2
\nencoding: utf8
\npool: <%= ENV.fetch(“RAILS_MAX_THREADS”) { 5 } %>
\nusername: PUT YOUR USERNAME
\npassword: PUT YOUR PASSWORD
\nsocket: \/var\/run\/mysqld\/mysqld.sockdevelopment:
\n<<: *default
\ndatabase: activeadmin_development# Warning: The database defined as “test” will be erased and
\n# re-generated from your development database when you run “rake”.
\n# Do not set this db to the same as development or production.
\ntest:
\n<<: *default
\ndatabase: activeadmin_test<\/p>\n
\n# like your database password, in your source code. If your source code is
\n# ever seen by anyone, they now have access to your database.
\n#
\n# Instead, provide the password as a unix environment variable when you boot
\n# the app. Read http:\/\/guides.rubyonrails.org\/configuring.html#configuring-a-database
\n# for a full rundown on how to provide these environment variables in a
\n# production deployment.
\n#
\n# On Heroku and other platform providers, you may have a full connection URL
\n# available as an environment variable. For example:
\n#
\n# DATABASE_URL=”mysql2:\/\/myuser:mypass@localhost\/somedatabase”
\n#
\n# You can use this database configuration with:
\n#
\n# production:
\n# url: <%= ENV[‘DATABASE_URL’] %>
\n#
\nproduction:
\n<<: *default
\ndatabase: activeadmin_production
\nusername: activeadmin
\npassword: <%= ENV[‘ACTIVEADMIN_DATABASE_PASSWORD’] %><\/p>\n<\/div>\n
\n> rake db:create<\/p>\n