Mysql, Development environments, bits and pieces

Development environments

Self contained development environments.

Laragon

Windows only but very comprehensive.
Everything you need for website development in one portable stack, i.e. the installation folder can be moved at will.

Kalabox

Similar idea to Laragon, everything you need for development in a single install.
Cross platform and more heavyweight than Laragon, based on Virtualbox and Docker containers.

MySQL

Bit of a problem this a.m.
Added a user (me) to a local mysql install, subsequent attempt to grant all privileges failed, e.g.

mysql> grant all privileges on *.* to 'ajpowell'@'%';
ERROR 1524 (HY000): Plugin '*176062F4F1A51FD94D136C1FB9CB2165D540D234' is not loaded

The fix is straightforward, update the plugin used for authentication in mysql.user, e.g.

mysql> update mysql.user SET plugin = 'mysql_native_password' where user = 'ajpowell';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected, 4 warnings (0.05 sec)

mysql> grant all privileges on *.* to 'ajpowell'@'%';
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected, 4 warnings (0.05 sec)

This appeared to be caused by an issue with the version of PHPMyAdmin I was using.
As an aside, it is possible to query the authentication_string from one MySQL server and update a different server to transfer a password from one server to another.
Obviously the plugin must also match for authentication to succeed.
Don’t try this at home. If you break your server don’t blame me.