All geek questions in one place

# 1100 - The table "pma__tracking" was not locked with LOCK TABLES - PHPMyAdmin, easyPHP

I am trying to just start creating a table script in PHPMyadmin; using simple phr. and this gives me this problem:

#1100 - Table 'pma__tracking' was not locked with LOCK TABLES

When I run the script on the WAMP PHPMyadmin server, I do not encounter this problem. script is successfully executed. same script. The same version of PHPmyadmin for both.

I can not find any help on the Internet, I assume that this is due to user rights?

This is the latest version of easyPHP.

Any ideas what creates this error, and how should I fix it?

+7
source share
3 answers

Go to the phpMyAdmin config.inc.php file, there should be:

 /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = 'your_root'; $cfg['Servers'][$i]['controlpass'] = 'your_password';
+16
source

The solution is simple

Open the .SQL file in notepad and

find

  LOCK TABLES

and replace it with

  #LOCK TABLES
+3
source

Open sql file in any editor

find LOCK TABLES and replace it with #LOCK TABLES

0
source

Source: https://habr.com/ru/post/974388/

More articles:


All Articles