I am trying to set up my database in MySQL using XAMPP. I am doing this via phpMyAdmin on localhost(Apache is running). The only action on my part is typing in a new, unused, name for a database, click create and...
this error occurs:
Error
SQL query: DocumentationEdit Edit
SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'stuff_tessss' AND `table_name` = '' AND FIND_IN_SET('CREATE DATABASE',tracking) > 0
MySQL said: Documentation
#1932 - Table 'phpmyadmin.pma__tracking' doesn't exist in engine
The database is showing in the list of databases. If you were to click on one, it takes forever and a day to not load.
I've tried researching and implementing the other 1932 error solutions on stack and other places but to no avail.
Here are the following versions for the tech I am utilizing:
OS X El Capitan - 10.11.1
Server version: Apache/2.4.16 (Unix)
PHP 5.6.15 (i had to reinstall with -intl extensions because CakePHP was complaining about a dependency)
CakePHP 3.0 (this required installation of Composer to utilize cakePHP from command line, which I believe runs off of PHP)
mySQL Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64)
XAMPP 5.6.14-4
I've read all sorts of solutions such as run it in Linux, or using an older version of XAMPP, etc. I figured there is a smarter person out there who might know the solution. I mainly had a hard time trying to figure out where to research, as well.
If anyone who could point me in the right direction I would greatly appreciate it!
解决方案
Finally, I find the solution.
We can find there really exists the table 'pma__tracking' when we expand the phpmyadmin database.
But the system error call on #1932 - Table 'phpmyadmin.pma__tracking' doesn't exist in engine.
So just try to remove the old pma__* database first and reconfig them later.
1.Remove the wrong tables in xampp's installation path and remove all the files in var/mysql/phpmyadmin/, which are similar like pma__bookmark.frm/pma__bookmark.ibd...
2.Reinstall the sql of phpmyadmin, which located in phpmyadmin/sql/, something like 'create_tables.sql', run them with mysql < create_table.sql, etc.
Then it works.