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