[BlueOnyx:23476] #1054 - Unknown column 'Event_priv' in 'field list'

[Colin Jack]

Quick question.

5209R - up to date.

I have imported a database and created user and privs from the command line.
Database won't connect so opened up phpMyAdmin and when I try and check privs I get:

#1054 - Unknown column 'Event_priv' in 'field list'.

I get this on all databases - including mysql - not only the imported one.

Looked through old threads and found "[BlueOnyx:08094] phpMyAdmin error with Privileges" (8 years ago! 😊)
Looked on the Blueonyx.it FAQ and found Michael's recommendation after CMU importing databases:

Fix the MySQL privilege table and do any conversion that may be required, but substitute "your-mysql-root-password" with your actual MySQL root password:
/usr/bin/mysql_fix_privilege_tables your-mysql-root-password

Tried that and command not found. Looked in /user/bin and sure enough, not there.

Any advice please.

Colin