Update 2021: Sequel Ace is a good similar alive alternative: (Credits to Maciej Kwas's answer)Īll the other solutions here are recommending changing your DB settings (making it less secure, as advertised by MySQL) for the tool you are using. Update 2020: Sequel Pro is officially dead but unofficially alive! You can find the " nightly" builds that don't have this issue (i.e. Don't downgrade your DB because of a tool. 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 The my.cnf file is located in /etc/my.cnf on Unix/Linuxįor 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. Do it only on fresh installs, because you may lost your db tables otherwise. Quick fix (destructive method)Īpple Logo > System Preferences > MySQL > Initialize Database, then type your new password and select 'Use legacy password'Īfter restart you should be able to connect. Login to mysql server from terminal: run mysql -u root -p, then inside shell execute this command (replacing with your actual password):ĪLTER USER IDENTIFIED WITH mysql_native_password BY '' Įxit from mysql shell with exit and run brew services restart mysql. Go to my.cnf file and in section add line:ĭefault-authentication-plugin=mysql_native_password mysql + homebrewīasically you will have to perform some actions manually, however- your database data won't be deleted like in solution below This is because Sequel Pro is not ready yet for a new kind of user login, as the error states: there is no driver.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |