GSoC 2015 : Weekly Report #10 : RFE #1396 & others
Task(s) completed: None
Tasks worked upon:
Scheduled Deadline: 9th August
Completed on: NA
1. I started working on the last feature on the timeline i.e. RFE #1396 : Support MySQL 5.6 SHA256 secure password
I referred extensively to the documentation. Here the versions of MySQL were quite important as this area of ALTER USER syntax, CREATE USER syntax and the newly added sha256 authentication plugin are some of the major changes that have been done in the recent versions.
So, an extra bit of care has to be taken that phpMyAdmin shows only the options which will work with the current version of MySQL server that the user is using.
But the documentation and good head-starts by Isaac, my mentor, helped a lot and I have implemented the changes required here. You can refer to the description of the PR for more details regarding what changes have been made. Isaac is currently reviewing the behavior on various versions of MySQL server so that we can ensure that this does not break the normal usage with previous versions.
2. I realized that we display a notice below on server_privileges.php i.e. User Accounts Tab, saying that phpMyAdmin takes the privileges shown on that page directly from the `mysql` db. So for this changed privileges to take effect, one has to run the FLUSH PRIVILEGES query and we provide a link which runs this query.
But I realized that query is obviously going to fail if the user does not have the RELOAD privilege. So, we should make the visibility of this notice conditional, so I and Isaac discussed and decided to go ahead with this. I have made the PR with related changes here .
Also, while I was working on RFE #1396 and waiting for the Travis CI’s build reports, I realized that even though they were not failing but they were showing some notices about ‘Not supported query’. I immediately realized that this were introduced in commit at  and fixed the problem with PR at .
 : https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
 : https://dev.mysql.com/doc/refman/5.7/en/create-user.html
 : https://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html
 : https://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html#priv_reload
 : https://github.com/phpmyadmin/phpmyadmin/pull/1797
 : https://github.com/phpmyadmin/phpmyadmin/commit/d014dbcc293118e2dd43ba2d36465b745537d5f8
 : https://github.com/phpmyadmin/phpmyadmin/pull/1796