Graphical sql browser for Macs
A graphical user interface for mysql database management on OSX.
Questions tagged [sequelpro]
249 questions
2
votes
1 answer
Sequel Pro closes Laravel Homestead SSH session
Ever since upgrading to the newest version of Laravel Homestead (v0.4.0), I'm having a weird issue where when I try to log in to Sequel Pro, it disconnects my Homestead SSH and does not let me back in unless I do vagrant suspend followed by vagrant…
noobmaster69
- 2,985
- 3
- 27
- 44
2
votes
0 answers
Importing a DB is throwing 1064 an error in your SQL syntax and/or encoding errors
I've been trying to export a DB from a hosted phpMyAdmin interface and import it locally either into phpMyAdmin or using SequelPro. This never used to be a problem. But recently when I import the DB in my local phpAdmin GUI I get an error of the…
Seb
- 723
- 1
- 6
- 11
2
votes
2 answers
Connecting a new Rails app to an existing MySQL database
I have a brand new Rails app that I want to hook into an existing MySQL database to do some reading and writing. I've already edited my database.yml file to connect to the new db. rails c and rails s don't throw errors which lead me to believe that…
Zack Shapiro
- 6,648
- 17
- 83
- 151
2
votes
1 answer
Create Sequel Pro "favorites" from command line?
I'm writing a bootstrapping script to automate some of the setup of a new developer's Mac computer. So far, I've been able to install SP from the command line using brew cask:
brew cask install sequel-pro
Is it possible to then create SP…
mopo922
- 6,293
- 3
- 28
- 31
2
votes
2 answers
MySQL: DELETE FROM using a multi conditional "not equal to" WHERE
Hah. So. I've been playing with this particular query where I'm trying to delete a large swath of rows but I end up not doing what I'm expecting. I've run various variations of this query and I'm not having any luck.
Basically I'm trying to do…
romanchukenator
- 97
- 1
- 6
2
votes
1 answer
mysql windows remote access
I've installed MySql on my Win2k3x86 vm box and am trying to connect to it using SequelPro on my Mac so I can run a large sql statement (~30mb - SQL Workbench locks up loading it). MySql was installed with all the developer default options and…
frumbert
- 2,323
- 5
- 30
- 61
1
vote
1 answer
current_timestamp() vs CURRENT_TIMESTAMP for default value on TIMESTAMP column (mariadb:latest/mysql, laravel, sequel pro)
What is the difference between CURRENT_TIMESTAMP and current_timestamp() ?
I'm using laravel, and in the laravel migration file for my Tasks table I have…
Pablo Camara
- 460
- 4
- 13
1
vote
0 answers
Different character set in different IDE for MySql DB
Table Structure:
CREATE TABLE `cs_menuitem` (
`menuitemid` int(11) NOT NULL AUTO_INCREMENT,
`catid` int(11) DEFAULT NULL,
`itemname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`menuitemid`),
KEY `fi0` (`catid`)
)…
Ahmad Asjad
- 825
- 1
- 8
- 29
1
vote
1 answer
I can't use Sequel Pro to connect to my Sail PHPMyAdmin
I'm using Sail in my Laravel 8 project and I can't find a way to use Sequel Pro to see my database.
When I run ./vendor/bin/sail up -d, my containers are running perfectly and I can access to my PHPMyAdmin in http://localhost:8080/ using these…
Jérôme
- 978
- 1
- 9
- 22
1
vote
2 answers
Why default INT(11)
In using SequelPro it uses a default INT length (for display!) of 11 when creating a table. For example:
CREATE TABLE `tbl` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
My question is…
David542
- 104,438
- 178
- 489
- 842
1
vote
1 answer
Failing to connect to Sequel Pro with '127.0.0.1', but can connect via terminal with 'localhost'
I have a project running on Docker and I'm able to connect to the database through the terminal:
mysql -h localhost -P 33060 --protocol=tcp -u 'notmyrealusername' -p
This works fine and I'm able to show the tables from the database.
However, when…
Brad Ahrens
- 4,864
- 5
- 36
- 47
1
vote
0 answers
Can't access localhost on Sequel Pro
i've just updated to big sur
and i'm using this tutorial to setup localhost in mac
https://websitebeaver.com/set-up-localhost-on-macos-high-sierra-apache-mysql-and-php-7-with-sslhttps
but then i got caught on error in sequel pro
what can i do to…
Dava Eranda
- 29
- 1
- 1
- 8
1
vote
0 answers
Cannot connect to a database created from LANDO "Access denied for user 'lamp'@'%' to database 'lando_test_cli'"
i am having an issue while trying to connect a database that I created in LANDO. There is my list of databases in LANDO :
+--------------------+
| Database |
+--------------------+
| information_schema |
| lamp |
|…
ElCarraco
- 51
- 4
1
vote
2 answers
Laravel-8:php artisan migrate not working
I tried running command: php artisan migrate, but it gave me below error.
ERROR:
Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('mysql.infoschema'@'localhost') does not exist (SQL:…
Akansha
- 11
- 1
- 2
1
vote
1 answer
How to open a .sql file made with Sequel Pro (MAC) on Windows?
I have a .sql file containing code to create a database. This file has been created using Sequel Pro SQL dump Version 4096, a software running on Mac.
However, I am on Windows and I just can't find out how to run this file successfully.
I have…
Paul
- 2,850
- 1
- 12
- 37