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 request timed out.
Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
can't figure out what I am missing
This is because Sequel Pro is not ready yet for a new kind of user login, as the error states: there is no driver.
mysql + homebrew
Basically you will have to perform some actions manually, however- your database data won't be deleted like in solution below
Go to my.cnf file and in section
[mysqld]add line:default-authentication-plugin=mysql_native_passwordLogin to mysql server from terminal: run
mysql -u root -p, then inside shell execute this command (replacing [password] with your actual password):ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '[password]';exit from mysql shell with
exitand runbrew services restart mysql.
Should work.
Quick fix (destructive method)
Quick fix for non-homebrew installs:
Apple Logo > System Preferences > MySQL > Initialize Database, then type your new password and select 'Use legacy password'
After restart you should be able to connect. Do it only on fresh installs, because you may lost your db tables otherwise.
my.cnf
The my.cnf file is located in /etc/my.cnf on Unix/Linux
Alternatives
For those who is still struggling with Sequel Pro problems: Sequel Pro was a great product, but with tons of unresolved issues and last release being dated to 2016 perhaps it's a good idea to look for some alternatives. There is a fork of SequelPro called SequelAce that seems to be pretty stable and up-to-date, it keeps similar functionality, similar look and feel, yet at the same time it is devoid of old Sequel Pro problems- MySql can't make column auto_increment
- Insert auto increment primary key to existing table
- 3 mysql table join but not getting expected result that i want
- MySQL insert_id returning null even though there was an insert
- mysql select query within a serialized array
- MySQL: Large VARCHAR vs. TEXT?
- php_network_getaddresses: getaddrinfo failed error in Docker's adminer
- Correlated queries - In derived tables, can I have many nesting levels?
- Is there a MySQL option/feature to track history of changes to records?
- When is a database called as an Embedded database?
- Multiple foreign keys from one table to same field in another table in Laravel
- Datetime-value's time inserted incorrectly in one column but not in another MYSQL
- Syntax diagrams for MySQL
- Converting currency symbols '$' '£' to html code $ £?
- Create Index in mysql not working
- Incorrect string value: '\xEF\xBF\xBD' for column
- Understanding inner join in recursive CTE (MySQL)
- Update MySQL table with rank number of duplicates by name
- Mysql query for 3 tables & user meta
- Setting up new instance of MySQL what is Current Root Password?
- How to change the CHARACTER SET (and COLLATION) throughout a database?
- How to resolve circular foreign key constraints with NOT NULL in Hibernate
- mysql join to record first one which is not matched before
- Conditional statement in migration doesn't work laravel
- Mysql ERROR at line 1153: Unknown command '\'
- How do I find the command causing a replication error in MySQL
- Wordpress Meta Value (Serialized) Filter
- Can you access the auto increment value in MySQL within one statement?
- Can't connect to RDS instance from EC2 instance
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)