Ubuntu 16.04 mysql_old_password not loading

Question

I want to connect to the mysql database on an external server using the shell command. Ubuntu version 16.04.

 mysql -uXXXXXX -pYYYYYY -h domain.com

I get an error:

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2059 (HY000): Authentication plugin 'mysql_old_password' cannot be loaded: /usr/lib/mysql/plugin/mysql_old_password.so: cannot open shared object file: No such file or directory

Answer 1

Perhaps you just need to install the mysql client (mariadb) by running the command:

sudo apt-get install mariadb-client

The above command fixed it on my Ubuntu 16.04.2 LTS installation when I had this problem.

Answer 2

Password hashing has changed since MySQL 5.7.5, so many clients and recent versions of MySQL no longer support insecure passwords prior to 4.1.

, MySQL 4.1+

: fooobar.com/questions/86971/... , .

: fooobar.com/questions/86971/... ,

Answer 3

mysql?

.

Plugins that perform their own authentication, which matches the password in the Password column in the account row. The mysql_native_password plugin implements authentication based on its own password hashing method. The mysql_old_password plugin implements its own authentication based on the older (before 4.1) password hashing method (and now it is deprecated).

you can try passing a plugin like

mysql --default-auth=mysql_old_password -u XXXXXX -pYYYYYY -h domain.com

Help: 7.1.2 Old Native Authentication Plugin