[phpMyAdmin Developers] Cannot Change or Set Passwords
justin at mcmastertek.ca
Sun Feb 7 17:44:07 CET 2016
I am running phpMyAdmin 220.127.116.11 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)
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
Version information: 18.104.22.168 (up to date)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Developers