[phpMyAdmin Developers] Cannot Change or Set Passwords

Justin McMaster justin at mcmastertek.ca
Sun Feb 7 17:44:07 CET 2016

I am running phpMyAdmin 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


    Version information: (up to date)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.phpmyadmin.net/pipermail/developers/attachments/20160207/b5d7d390/attachment.html>

More information about the Developers mailing list