phpmyadmin 5.2.0 + mariadb 10.88.0.1，檢視使用者權限時遇到"Not enough privilege to view users"(權限不足以檢視使用者)

場景：
 phpmyadmin 5.2.0
 mariadb 10.88.0.1

問題：
phpmyadmin點選使用者帳號(User accounts)頁籤時，無法顯示使用者，出現"Not enough privilege to view users"(權限不足以檢視使用者)錯誤訊息

解決方式：
執行以下語句，並重新啟動mariadb
use mysql;
INSERT INTO `tables_priv` (`Host`, `Db`, `User`, `Table_name`, `Grantor`, `Timestamp`, `Table_priv`, `Column_priv`) VALUES ('localhost','mysql','mariadb.sys','global_priv','root@localhost','0000-00-00 00:00:00','Select,Delete','');

ref:
https://stackoverflow.com/questions/60387072/not-enough-privilege-to-view-users-in-phpmyadmin

phpmyadmin在innodb表格資料超過50000筆時，無法正確抓到筆數並切換頁

 

從phpmyadmin 4.8.0後，因效能考量，預設50000筆內是用select count取得資料列數，超過50000筆時才用show table status，但常會造成取的筆數不對，因此可以把phpmyadmin的$cfg['MaxExactCount']參數加大:

$cfg['MaxExactCountViews'] = 0;//disable trying to count the number of rows in any view
$cfg['MaxExactCount'] = 0;//disable correcting the InnoDB estimates

或者去點擊table總表的row count的數字去更新也行 (沒試過)

ref:
https://docs.phpmyadmin.net/en/latest/config.html#cfg_MaxExactCount
https://docs.phpmyadmin.net/en/latest/faq.html#faq3-11
https://stackoverflow.com/questions/10811405/phpmyadmin-and-big-tables
https://www.kavoir.com/2012/07/make-phpmyadmin-show-exact-number-of-records-for-innodb-tables.html