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- System.NotSupportedException: Character set 'utf8mb3' is not supported by .Net Framework
- Enabling MySQL general query log with JDBC
- Join two tables where one table name is inside the other table
- Unable to make a remote api call to flask app(for MySQL connection) inside my apache server
- How can I set a numeric wildcard in MySQL?
- Your password does not satisfy the current policy requirements
- Weighted hierarchical cumulative sum
- MySql views performance
- Are MySql Views Dynamic and Efficient?
- Storing 2 same id of post table with different language into database
- Using multiple tables for lookup in MySQL
- mysql change innodb_large_prefix
- findAll() in Sequelize doesn't find a row created inside a transaction
- Unable to connect from MySQL Workbench to AWS RDS instance
- Spring Boot JPA MySQL : Failed to determine a suitable driver class
- How to count the number of groups of events that are more than 20 minutes from each other?
- How to properly save a complex object using EF Core
- Select query in MySQL
- Same table union from different databases
- How to generate a UUIDv4 in MySQL?
- Whats wrong with my query with CASE statement
- Select All Events with Event->Schedule->Date between start and end dates in CakePHP
- Insert custom date into mysql timestamp field
- Filtering mysql data using nested json_table returns "Incorrect arguments"
- How to fix "Error executing DDL "alter table events drop foreign key FKg0mkvgsqn8584qoql6a2rxheq" via JDBC Statement"
- Directus is not connecting with mysql over SSH server
- Inserting and selecting UUIDs as binary(16)
- How to fix Authentication method caching_sha2_password not supported by any of the available plugins in Visual Studio
- exception emyxerror in module mysqlquerybrowser exe at 00111E52
- Efficiently Querying Nearby Warehouses Based on Latitude and Longitude Within a Specified Radius