Graphical sql browser for Macs
A graphical user interface for mysql database management on OSX.
Questions tagged [sequelpro]
249 questions
0
votes
1 answer
Access local postgres with SequelPro
I am using Sequel Pro and want to access my local Postgres DB.
When I get prompted in sequel pro to add connection details for my db I oblige:
And then when I click connect I get:
I am on a mac running Catalina 10.15.3.
The database I am running…
Brainmaniac
- 2,203
- 4
- 29
- 53
0
votes
0 answers
Docker - connect to mysql with sequel pro
I know this question has been asked before, but i have tried so many things that i really think i lost what is right or not, so to be quick, when i do docker ps on my terminal, i have the mysql image:
CONTAINER ID IMAGE COMMAND…
Japa
- 632
- 7
- 30
0
votes
0 answers
The SSH Tunnel could not authenticate with the remote host
I am trying to connect Laravel Forge database from Sequel pro. I am getting the "The SSH Tunnel could not authenticate with the remote host. Please check your password and ensure you still have access" error.
Initially I was asked to enter the…
Ben Jonson
- 565
- 7
- 22
0
votes
1 answer
I can't find the database(using sequel pro) migrated on homestead after I did the "php artisan migrate" command
I just new up a laravel project on homestead. I already ssh on my virtual machine, edited the .env file and run "php artisan migrate". it clearly ran with out issue. Now I want to view the database tables created using sequel pro. I can connect with…
Master Jon
- 11
- 2
0
votes
0 answers
Unable to Connect to Sequel Pro
When I have tried to access Sequel Pro I keep getting the following error message:
"Unable to connect to host 127.0.0.1 because access was denied.
Double-check your username and password and ensure that access from
your current location is…
Travis Kerr
- 31
- 4
0
votes
0 answers
Why does Sequel Pro have to connect to MAMP (or any other mySQL provider)
I thought Sequel Pro allows you to upload .sql and data so why must it be connected to MAMP for example? Am I missing some very basic point here?
Henry
- 5,195
- 7
- 21
- 34
0
votes
1 answer
mysql pivot using column and row numbers
I am stuck in this situation where I need to use Row Number and Column Number values from table's columns to derive the output mentioned below. I have tried everything - if/else, case when/then but not helping.
Any help/suggestions are really…
KabirM
- 1
0
votes
1 answer
Docker instance of MySQL is not setting root password -- any login without a password is allowed
I set up a new computer running macOS 10.14.5 and Docker Desktop community 2.0.0.3 (31259) and I noticed that my MySQL container wasn't being created properly. This is the command that I had run on my previous computer:
docker run --name…
Everett
- 8,746
- 5
- 35
- 49
0
votes
4 answers
Saving changes in php artisan tinker
I am working on a Laravel project. First, have run a migration and created a Blueprint for the table:
php artisan migrate
I edited the migration by creating a Schema with the following structure
Schema::create('donations', function (Blueprint…
Ewa Szyszka
- 69
- 2
- 10
0
votes
0 answers
codeigniter create ci_session table crashes mysql
crashes after running Codeigniter create table my sql query to create session table :
CREATE TABLE IF NOT EXISTS ci_sessions (
id varchar(128) NOT NULL,
ip_address varchar(45) NOT NULL,
timestamp int(10) unsigned DEFAULT 0 NOT NULL,
data blob NOT…
Alzaabi98
- 35
- 1
- 9
0
votes
1 answer
How to reset password for Sequel Pro?
It is unclear for me how to reset the password to access the Sequel Pro. Those are my settings:
Name: localhost
Host: 127.0.0.1
Username: root
Port: 8889
How to reset password/ solve this set up of Sequel Pro issue?
Ewa Szyszka
- 69
- 2
- 10
0
votes
1 answer
How to copy a database table column to another database
I am using Sequel Pro to copy data from an old database to a new one. I know you can select rows and copy them as an SQL INSERT etc. But the layout for my new data base has changed and I no longer want to copy all the data in the rows. I just need…
Reece
- 2,581
- 10
- 42
- 90
0
votes
0 answers
Cannot Connect to MySQL local server with SequelPro MySQL said: Incorrect database name
I have create a mysql database locally in the unix macos Mojave environment, when entering mysql and entering command
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| cms_blog |
|…
mibbit
- 4,997
- 3
- 26
- 34
0
votes
2 answers
How to count the total number of results before a hyphen?
I am looking to count the number of results from a SQL count query, the results currently have like 50 results, but in reality there are only 5 results... the results appear in a format such…
user3296793
- 270
- 2
- 14
0
votes
1 answer
Unable to start mysql 5.6 on Mac
I installed mysql 5.6 using homebrew but haven't been able to start it/login using Sequel pro.
When I run mysql.server start in the terminal I am getting this error -
ERROR! The server quit without updating PID file
I had installed mysql 8…
code4fun
- 2,661
- 9
- 25
- 39