Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

249 questions
3
votes
0 answers

How do I connect to MySQL DB using a jump host with Sequel Pro

I want to connect to my MySQL database as below [A: local host] -> [B: jump host] -> [C: target host] => [D: MySQL host] Is it possible with Sequel Pro?
ln9187
  • 730
  • 1
  • 7
  • 23
3
votes
0 answers

Unable to connect Sequel Pro with mysql docker container

I feel like this should be an easy fix but I can't seem to figure this out. I just installed docker and ran: docker run -d --name test-mysql -p 3306:3306 -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -e MYSQL_DATABASE=test mysql I did this to create my first…
Ghostdragon777
  • 53
  • 3
3
votes
6 answers

Store SQL query results returned from the Server

I am using Sequel pro to connect to a remote server on which the mysql database is running. I am using Mac and the server has Linux installed. I want to store that result (i.e. the table that you can see in the picture) as a text file on my Mac.…
HimanAB
  • 2,443
  • 8
  • 29
  • 43
3
votes
1 answer

How can I connect to a local sqlite3 database?

I'm running a local node.js app on localhost:3000. It has a database named database in a file called db.sqlite. I tried to connect to the database with the host localhost:3000, but sequel pro says MySQL said: Unknown MySQL server host…
Himmators
  • 14,278
  • 36
  • 132
  • 223
3
votes
2 answers

Converting VARCHAR column to INT in MySQL / Sequel Pro

I'm trying to set the column in my database from VARCHAR to INT (values are already in DB) When doing this action, the following happens (example): | number (varchar) | number (int | | 20090911913 > 2147483647 | | 3009092113 > 2147483647…
Orion
  • 227
  • 1
  • 4
  • 14
3
votes
4 answers

vagrant sequel pro SSH Tunnel remote host can't connect, bad password

I'm new to MySQL and Vagrant and spent several hours trying to set both up. I can connect to MySQL from the command line with: mysql --host=127.0.0.1 --user=root --password=[my_password] I'm trying to connect with Sequel Pro and following a couple…
KM617
  • 137
  • 1
  • 3
  • 16
3
votes
0 answers

Kitematic + MariaDB + SequelPro

I'm recently using Kitematic (Docker), Struggling between Vagrant and Docker. Working with Docker and Kitematic is smooth, I can create, initiate a DB via Console. But If I want to manipulate the db via sequel pro, or just import from local, I…
Locke
  • 629
  • 1
  • 5
  • 21
3
votes
1 answer

Sequel Pro - import .sq3 db

Using MAC, when I Import a database formatted as sq3 I've this error: An error occurred when reading the file, as it could not be read in the encoding you selected (Autodetect - Thai (Windows, DOS)). Only 0 queries were executed. How do I import…
Stealth
  • 43
  • 5
3
votes
1 answer

How to connect to aws Redshift db from mac

I am using a mac and I typically use Sequel Pro to interact with sql databases. Usually I use mysql, but I understand redshift uses Postgres. When I try to connect to my Redshift db, should I use the IP, or the "endpoint"? Also when I try to…
johncorser
  • 9,262
  • 17
  • 57
  • 102
3
votes
1 answer

Same SQL code returning different results sets on different MySQL clients

I have some SQL code returning a result set as expected in both of the MySQL clients, namely MySQL Workbench and Sequel Pro. However, when I put the SQL code in a stored procedure (SP), it returns a result set with one line (different than before)…
Muhsin Zahid Ugur
  • 533
  • 1
  • 5
  • 14
3
votes
2 answers

Why won't my php connection to mysql server work?

Hi I'm trying to send information to my local mysql server that is shown in Sequel pro. I have a form in html which looks like this: register
Eksperiment626
  • 985
  • 3
  • 16
  • 30
2
votes
1 answer

MySql varchar length for emojis on Sequel Pro

I'm using MySql version 5.6.46 on Linux. I have a column name varchar(50) COLLATE utf8mb4_bin and ENGINE=InnoDB DEFAULT CHARSET=utf8mb4. When I tried to insert some data into the table. I find that, for a (1 byte in utf8), it can store 50…
matrix
  • 349
  • 3
  • 12
2
votes
1 answer

Sequel Pro gives 'Connection failed!' error using Docker Mysql container

I am unable to connect my Sequel Pro to my docker mysql container. I keep getting the following error message: I have a docker-compose.yml ; db: image: mysql:5.7 ports: - "33071:3306" command:…
theSeeker
  • 297
  • 4
  • 12
2
votes
1 answer

DDEV: Sequelpro throws an "unrecognized selector" error when I open it with the ddev sequelpro command

Ever since I changed my ddev config to use mysql_version: "8.0" the ddev sequelpro command opens sequelpro but I get an unrecognized selector sent to instance 0x600000329640 error after sequelpro opens. Is there a known solution to this problem?
Ryan McVeigh
  • 161
  • 5
2
votes
0 answers

Fastest way to copy databases and tables with sequel pro between servers

I know, that i can do a dump and import it to another server. But ist there a faster way to copy databases or tables between servers with sequel pro?
mart
  • 354
  • 3
  • 14
1 2
3
…
16 17