PhpMyAdmin error: table does not exist in the engine

Question

I installed XAMPP today on Ubuntu 14.04. I tried to create a new database in phpMyAdmin but got an error

# 1932 - Table 'phpmyadmin.pma__tracking' does not exist in engine

So, I searched a little Google, and I saw that I should import create_tables.sql, located in /usr/share/doc/phpmyadmin/example(if I remember correctly, but I could not find it there, but I found it in /opt/lampp/phpmyadmin/sql. To import, but I get the same error.

At first, I installed XAMPP 5.6.14 / PHP 5.6.14 twice, but no changes. Then I installed XAMPP 5.5.30 / PHP 5.5.30, but still no changes. I also tried changing the config.inc.php file (then I stop XAMPP and start it again).

Note. I see the phpmyadmin database, and if I expand it, I see that all the tables that create the problems exist:

I have no idea why this is happening or how to solve it. Can anybody help?

PS: I saw that this question was asked before, but none of the answers I found worked for me.

Answer 1

Since none of the solutions worked for me, I did the following:

• Open Nautilus (Linux file explorer) with root privileges: sudo nautlius.
• Go to the mysql directory: /opt/lampp/var/mysql.
• Delete phpmyadmin folder. This is phpmyadmin database in phpMyAdmin
• Copy the contents of the file create_tables.sql(found in /opt/lampp/phpmyadmin/sql) to another on your desktop calledsql.sql
• MySQL: /opt/lampp/bin/mysql -uroot -p
• mysql promp script phpmyadmin source /home/user/Desktop/sql.sql

.

Answer 2

/opt/lampp/phpmyadmin/config.inc.php:

$i = 1 /* */

/* */

$i = 1

phpMyAdmin,

1932-table-phpmyadmin-pma-tracking-doesnt-exist-in-engine

Answer 3

create_tables.sql, . .

/*
 * Servers configuration
 */
$i = 1;

Then I logged out of phpMyAdmin and logged in again. There were resolved problems. Logging out seems important here.