Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

249 questions
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
  • 3,337
  • 5
  • 35
  • 40
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
5
votes
1 answer

Exporting table with SequelPro into csv file

I'm trying to export a MySQL table into csv file using SequelPro, however the result file is not properly formatted. For instance, on the first column should the id, in some of the records there is a number, but in others there is text instead. This…
WagnerMatosUK
  • 4,309
  • 7
  • 56
  • 95
5
votes
3 answers

How to change a string to a date during import using Sequel Pro?

I'm trying to import a file into a MySQL table using Sequel Pro. I know I need to use STR_TO_DATE, but I can't figure out the right syntax. I'm getting a bunch of these errors for each row: [ERROR in row 1] You have an error in your SQL syntax;…
Tim Elhajj
  • 835
  • 1
  • 9
  • 16
5
votes
2 answers

Can't connect to MySQL

I'm trying to connect to MySQL, using Sequel Pro, something I have done many times before. Host 127.0.0.1, username root, no password. I get the following message: Unable to connect to host 127.0.0.1 because access was denied. Double-check your…
japem
  • 1,037
  • 5
  • 16
  • 30
4
votes
2 answers

Mysql remote connect over ssh to a kubernetes pod

Many devops use mysql connect over ssh to access to production database for various reasons and queries after successfull deploy mysql container to a digital ocean kubernetes cluster im able to ssh into the pod via : kubectl…
Sina Miandashti
  • 2,087
  • 1
  • 26
  • 40
4
votes
1 answer

Does MySQL support the bracket wildcard?

I tried using the brackets wild card and nothing came up. I'm using SequelPro (and I think that uses MySQL, though I could be wrong). Does it support the bracket [] wildcard? If not, what can I use in it's replacement? Here's an example -- SELECT…
Sebastian
  • 957
  • 3
  • 15
  • 27
4
votes
2 answers

Use seqel pro connect to AWS RDS

I was using the AWS free tier to setup my Rails project. However, I felt confused about why I can't connect RDS via sequel pro. Here is the VPC security group which RDS was using. I set the same host, username, pwd and database name in my rails…
rj487
  • 4,476
  • 6
  • 47
  • 88
4
votes
2 answers

Import null and improperly formatted datetime values into datetime column MySQL

I'm using a MySQL database with the Sequel Pro interface, and am new to SQL. I'm attempting to import data from a csv file and one of the columns I am importing into is of type datetime. However, the format I receive the data in is mm/dd/yy hh:mm…
djar
  • 69
  • 1
  • 1
  • 9
4
votes
1 answer

getting started with loops and iteration in sequel pro

I'm using sequel pro to select data from several tables. There are two things I need to do that seem to need a loop of some kind. I have never used any form of iteration in sql and can't find a beginners-level resource to learn from. Can anyone…
AJDncnsn
  • 53
  • 1
  • 5
3
votes
1 answer

I can connect to DB through Sequel Pro, but not through command line

I can connect to my db with Sequel Pro just fine, but I can't through the command line. I've followed their instructions here:…
Kaleidoscope
  • 3,609
  • 1
  • 26
  • 21
3
votes
0 answers

How to connect using SSL in Sequel Pro?

I've installed MySQL 8.0.17 on a Mac using brew install mysql and would like to connect to a local database using SSL. From https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html, it seems that I need the files in this snippet: I…
Kurt Peek
  • 52,165
  • 91
  • 301
  • 526
3
votes
3 answers

Can't connect to MySQL inside Docker container with SequelPro

How can I connect to MySQL inside my docker container that is hosted locally on my mac? I'm trying to connect via SequelPro and can't even get test connection to work. Here's my Docker command: docker run -it --name rodneys_mysql -p 3306:3306 -e…
Rod
  • 14,529
  • 31
  • 118
  • 230
3
votes
1 answer

ssh include directive not working

So ssh works fine through console/terminal, but when I am using a MySQL database client (Sequel Pro), it seems to somehow be using a different ssh version, and the include directive therefore doesn't work. It states that it is using the proper SSH…
ambe5960
  • 1,870
  • 2
  • 19
  • 47
3
votes
4 answers

Laravel/Homestead - can't connect to the DB

I have installed homestead on my machine and cloned a project from a remote repository, now I am trying to create a DB for my project. This is how my .env file looks…
Leff
  • 1,968
  • 24
  • 97
  • 201
1
2
3
…
16 17