Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

241 questions
107
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ō
  • 1,739
  • 2
  • 16
  • 28
68
votes
16 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
  • 979
  • 2
  • 7
  • 13
67
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?
Nunyet de Can Calçada
  • 3,615
  • 32
  • 127
  • 219
43
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
  • 2,409
  • 4
  • 15
  • 22
39
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
  • 4,261
  • 8
  • 55
  • 108
21
votes
5 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
  • 321
  • 1
  • 2
  • 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,409
  • 3
  • 14
  • 34
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
  • 27,490
  • 32
  • 129
  • 238
9
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
  • 767
  • 1
  • 5
  • 15
8
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
  • 6,673
  • 8
  • 43
  • 90
6
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
  • 179
  • 1
  • 1
  • 11
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,023
  • 2
  • 20
  • 26
6
votes
1 answer

How 'Set Default value' to 'NOW()' with Sequel PRO?

I have a MySQL table with some dates, I need that one of them have a default value equal to current time, I'm using 'Sequel Pro' to build the database, Then i wrote 'now()' (and 'GETDATE()') in default value, but doesn't work. Can someone do help…
Rui Martins
  • 1,503
  • 1
  • 22
  • 30
5
votes
1 answer

Authentication plugin error while connecting to MySQL database

I am working on macOS ver 10.13.5 - the newest one actually. I usually work with Laravel projects (5.6), and so I am using brew services isntaller to make local enviroment working. I am using PHP v 7.1.16, MySQL 8.0.11 and Valet in v. 2.0.12 PHP and…
user9211310
1
2 3
…
16 17