I have Ubuntu 18.04 and I get the error when trying to enter mysql from terminal: plugin mysql_native_password not loaded.
I began getting this error after changing it from "auth_socket" to native password.
I did that while trying to fix the error "access denied to localhost".
I have google many times but cannot find a solution.
Thanks.
1 Answer
If you are using Pure MySQL and are NOT using MariaDB, then there is no mysql_native_password.
mysql_native_password is a MariaDB-specific thing to provide more functionality in line with the native password functions that MySQL provides.
If you are using MySQL you do not need to set mysql_native_password - just create a user with the hostname match of the wildcard to match anything, then make sure your MySQL is listening on a network socket and not just a local UNIX socket.
