Using MySQL 5.7.17 instead of MariaDB: please add command mysql_upgrade -u root -p --force


  • | 369 points

    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.


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.