← Back to Upcase

Trying to connect Sequel Pro to localhost


(Jameson Trinker) #1

I’m building a new rails app that’s defaulted to mysql. I ran:

rails new project_board -d mysql

I’m running ruby 2.0, rails 4.0 and mysql 5.6.12

I installed mysql via homebrew

My database.yml file looks like this:

development:
adapter: mysql2
encoding: utf8
database: project_board_development
pool: 5
username: root
password:
host: localhost

But when I try to connect to Sequel Pro through this window:

I get the following error:

Unable to connect via the socket, or the request timed out.
Double-check that the socket path is correct and that you have the necessary privileges, and that the server is running.
MySQL said: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

I’ve also tried connecting via the standard method through 127.0.0.1 and it isn’t working either. Just curious if anyone has had this issue.


(Jameson Trinker) #2

Sorry, it’s not letting my image display. It’s the socket tab, with name: localhost and username: root.


(Jameson Trinker) #3

Never mind. I’m an idiot.


(David Lee) #4

What was the problem?


(Jameson Trinker) #5

I never started the mysql server in the terminal:

mysql.server start