I am running phpMyAdmin 4.5.4.1 on my FreeBSD server with MySQL 5.5.43 and I am unable to work with MySQL account passwords because of the Authentication Plugin ‘Native MySQL authentication’

 

This ‘plugin’ errors my MySQL commands so that I cannot create, change, edit, or set passwords by adding ‘IDENTIFIED WITH mysql_native_password’ to my SQL string.

 

To get this to work I have to take the SQL command that errors, remove that entry, and manually enter it in the SQL tab as a command line to create a user.

 

I cannot find any confirmation setting, plugin, or compiling option to turn this off.

 

Does anyone know how I can disable this feature so my phpMyAdmin works again?

 

    Server: Localhost via UNIX socket

    Server type: MySQL

    Server version: 5.5.43 - Source distribution

    Protocol version: 10

    Server charset: UTF-8 Unicode (utf8)

 

Web server

 

    Apache/2.2.31 (FreeBSD) PHP/5.6.16 mod_ssl/2.2.31 OpenSSL/1.0.2f DAV/2

    Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $

    PHP extension: mysqli Documentation

    PHP version: 5.6.16

 

phpMyAdmin

 

    Version information: 4.5.4.1 (up to date)

 

-Justin