How do I open a Rails Mysql database in Mysql Workbench?

mrudult Published at Dev

mrudult

I having trouble finding my mysql database files in Ruby on Rails project and opening it in MysqlWorkbench

This is my folder structure for a app

enter image description here

This is my database.yml

development:

  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: rawdy_development
  pool: 5
  username: root
  password:
  socket: /tmp/mysql.sock

I'm not finding my mysql database file to open in MySqlWorkbench.
Help.

paolobueno

Unlike sqlite, your rails project doesn't contain the MySQL database files, the database.yml file only contains info on how to connect to the database. In that case it's trying to connect through a unix socket file.

I'm not sure if Workbench can connect that way, but most likely the database server is located on your own machine at localhost, port 3306, using username root and a blank password, you should configure Workbench to connect to that server and use database rawdy_development, instead of opening a database file.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-6

Comments

0 comments

TOP Ranking

Article

How do I open a Rails Mysql database in Mysql Workbench?

How do I open a Rails Mysql database in Mysql Workbench?

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Unable to use switch toggle for dark mode in material-ui

grouping by column variables and appending a new variable based on condition

BigQuery - concatenate ignoring NULL

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Python Read Directory And Output to CSV

Remove adjacent duplicates in linked list in C

Angular 8. Unknown amount of http.get requests in array to call, must be sequential, what to use

How to keep curl session alive between two php processes?

Limit number of characters in uitextview

JMeter: Why get error when try to save test plan

Always setting the text cursor on Textbox

MTKView Displaying Wide Gamut P3 Colorspace

Vector input in shiny R and then use it

How to implement an authentication method using Spring Boot and JPA?

Laravel getting value from another table using eloquent

org.springframework.web.client.HttpClientErrorException: 401 null

When I click any button in my view page the form is submitted