Navicat v.8.0.28 also allows Virtual Grouping which provides better categorization for objects. This new version supports MySQL 5.1 new feature Scheduled Event, enabling users to set a schedule for any Event defined in MySQL.

6.4.1.PremiumSoft CyberTech Limited today announced the immediate availability of Navicat for MySQL v.8.0.28.Now you should be able to go back to your MySQL client and connect as normal. Note: can be the IP address of your computer which would allow access from your computer only or, in the case of a local development environment, you can use % to allow from any host. Now run the following SQL command, replacing, and as appropriate. Open a terminal window and connect to your MySQL instance via the command line mysql -u -pĮnter your MySQL password and press enter and you should be logged into your MySQL instance. Resolutionġ) You can, at a server level, revert to the mysql_native_password mechanism by adding the following to your MySQL configuration files ĭefault_authentication_plugin=mysql_native_passwordĢ) You can, at a user level, revert to the mysql_native_password mechanism via the following process This means that clients (Sequel Pro, HeidiSQL etc) that rely on the mysql_native_password won't be able to connect because of this change. The specific module can not be found ReasonĪs of MySQL 8.0, caching_sha2_password is now the default authentication plugin rather than mysql_native_password which was the default in previous versions. Every attempt to connect using your MySQL client results in the following errorĪuthentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not foundĪuthentication plugin 'caching_sha2_password' cannot be loaded.

You have installed MySQL 8 and are unable to connect your database using your MySQL client (Sequel Pro, HeidiSQL etc).

Navicat 8.0