Using MySQL 5.7.17 instead of MariaDB: please add command mysql_upgrade -u root -p --force
-
After just adding a folder with MySQL distrib (mysql-5.7.17-winx64), I got an error #1146 - Table 'performance_schema.global_variables' doesn't exist when clicking on InnoDB or ISAM engine links on http://localhost/phpmyadmin/server_engines.php page (i.e. for InnoDB link to http://localhost/phpmyadmin/server_engines.php?engine=InnoDB).
The problem is resolved with command:
mysql_upgrade -u root -p --force
from the MySQL distrib folder (\laragon\bin\mysql\mysql-5.7.17-winx64 in my case).
While laragon is great abt watching for new alternative MySQL or MariaDB distrib folders added to \laragon\bin\mysql\ and setting up ini settings for MySQL, just to eliminate this handiwork, please add the command (mysql_upgrade -u root -p --force) along with my.ini settings out of the box.
369 points