Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

249 questions
129
votes
7 answers

Sequel Pro and MySQL connection failed

I just installed mysql on mac from Homebrew brew install mysql mysql -V mysql Ver 8.0.11 for osx10.13 on x86_64 (Homebrew) from terminal it works and I can login to mysql but from Sequel Pro it says Unable to connect to host 127.0.0.1, or the…
Hattori Hanzō
  • 2,349
  • 4
  • 19
  • 36
76
votes
4 answers

How do you execute a query in Sequel Pro?

I want to execute a query in a MySQL DB using Sequel Pro, but I do not see a Run button. How do I execute my query?
Nuñito Calzada
  • 4,394
  • 47
  • 174
  • 301
70
votes
15 answers

Unable to access MySQL after it automatically generated a temporary password

I have erased and installed OSX 10.11 El Capitan and I have been following through this tutorial to get MySQL up and running on the new OS X. The first step was to download MySQL For Mac OS X 10.9 (x86, 64-bit), DMG Archive (works on 10.11, they…
Cheetah Felidae
  • 999
  • 2
  • 7
  • 14
55
votes
3 answers

Is there a way to export my existing connections from MySQL Workbench to Sequel PRO

Is there a way to export my existing connections from MySQL Workbench to Sequel PRO I have been browsing through all options I could and I cant find an option that would let me export all my connections from workbench I have a lot of connections in…
Nick Div
  • 5,338
  • 12
  • 65
  • 127
46
votes
1 answer

How do I add a foreign key in SequelPro?

I'm using Sequel Pro 0.9.9.1 Build 3408. I want to add a foreign key to a table and also on delete cascade. I can't find anything in the GUI that allows me to add foreign keys. Anyone know how to do this?
Padraig
  • 3,197
  • 4
  • 18
  • 26
27
votes
6 answers

Sequel Pro with Mysql in Docker

I build 2 docker container with docker-compose. I use Docker on Mac, no boot2docker. version: '2' services: drupal-web: image: drupal:latest ports: - "8080:80" depends_on: - mysql-server …
freemindghost
  • 381
  • 1
  • 3
  • 10
14
votes
6 answers

Can't connect to MySQL server on (ip or domain name)

I'm trying to configure a web server (Debian 7). I followed this tutorial. I'm renting my server thanks to gandi.net service. And i have now apache2, mysql, php5 up and running. I connect to it using following command on terminal : ssh…
Ambroise Collon
  • 3,839
  • 3
  • 18
  • 37
12
votes
10 answers

Connect to MySQL on Vagrant instance with Sequel Pro

I am running Laravel on Vagrant and I am trying to connect Sequel Pro. I have just started using Vagrant, I have followed a few tutorials on connecting to Sequel Pro however they were all unsuccessful. Here is my Vagrant file: # -*- mode: ruby -*- #…
user3692109
  • 123
  • 1
  • 1
  • 5
10
votes
2 answers

How to connect to mysql running on docker using Sequel Pro

I have a docker-machine up and it has a mysql container running. ~ ▶ boot2docker ip 192.168.59.103 ~ …
Anthony
  • 33,838
  • 42
  • 169
  • 278
10
votes
5 answers

Vagrant SSH Tunnelling after using `vagrant ssh`

My MySQL client (Sequel Pro) is set up to connect to Vagrant over SSH. I've setup the following in my ~/.ssh/config file: Host vagrant HostName 127.0.0.1 CheckHostIP no Port 2222 User vagrant IdentityFile…
Small Hadron Collider
  • 809
  • 1
  • 6
  • 17
9
votes
1 answer

How to format SQL code in SequelPro locally?

In SequelPro, there's a built in SQL format bundle. This bundle using a web based SQL format API, hence it requires internet connection. Is there a solution to format code locally?
Nick
  • 8,451
  • 13
  • 57
  • 106
8
votes
3 answers

How do I import data from a csv to SequelPro?

I have a small data file and I'd like to analyze it with SequelPro. I have it connected to a MySQL server running on my computer. When I try to import, the Import button is just greyed out.
Sebastian
  • 957
  • 3
  • 15
  • 27
7
votes
6 answers

Can't connect sequel pro with mysql

I downloaded and installed mysql community server GPL version 5.7.13 on my Mac OSX El Capitan. Then I downloaded sequel pro. I tried to connect mysql using socket. I used the name localhost and username root and kept the password blank. When I tried…
MD Abid Hasan
  • 339
  • 1
  • 3
  • 15
6
votes
2 answers

Disable Strict mode in Sequel Pro

How to disable mysql strict mode in Sequel Pro on Mac? I got this error sql_mode = only_full_group_by. Been trying to find the solution, but nothing helps.
Syamim Hazmi
  • 81
  • 2
  • 7
6
votes
1 answer

Open a Sequel Pro connection from command line

I have a database on a SaaS platform (Pantheon), and the connection string changes frequently (multiple times per day). This makes Sequel Pro favorites pretty useless. I can easily fetch the new connection string from Terminal, and I can launch…
aaronbauman
  • 3,549
  • 2
  • 24
  • 30
1
2 3
…
16 17