Bug #98833 Lock tables does not work from phpmyadmin.... But of from SQL Client as SQLyog
Submitted: 4 Mar 14:45 Modified: 6 Mar 16:32
Reporter: Axel Falck Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version: OS:Microsoft Windows (uwamp + MySQL 5.7.11)
Assigned to: MySQL Verification Team CPU Architecture:Any (64 bits)
Tags: Lock table unlock phpmyadmin client SQL

[4 Mar 14:45] Axel Falck
Description:
Hey 

I try to lock a table into phpmyadmin UI with following syntax

LOCK TABLES my_table WRITE

I have a little red cross wich said that this syntax seems not correct... Execute button returns no error.

the SHOW OPEN TABLES FROM my_base displays the table not used !
And in fact the table is not locked. I can do a SELECT * FROM my_table fromother SQL session.

If I use the SQLyog GUI client the same command is working fine and the table is locked.

So seems an error exists into the SQL parser.

A quick fix should be welcome

Thanks

How to repeat:
By the command explain previously
[4 Mar 17:50] Axel Falck
Hey 

I try to lock a table into phpmyadmin UI with following syntax

LOCK TABLES my_table WRITE

I have a little red cross wich said that this syntax seems not correct... Execute button returns no error.

the SHOW OPEN TABLES FROM my_base displays the table not used !
And in fact the table is not locked. I can do a SELECT * FROM my_table fromother SQL session.

If I use the SQLyog GUI client the same command is working fine and the table is locked.

So seems an error exists into the SQL parser.

A quick fix should be welcome

Thanks
[6 Mar 10:32] Axel Falck
I confirm the bug into PHPmyadmin GUI.

If I use mysql command line under Ms-DOS windows the lock is done

and the "show open tables from my_table" command under phpmyadmin shows the locked table

So the commande lock tables is really buggy into the phpmyadmin GUI (my version is 4.5.4.1)

Any infos ???
[6 Mar 10:35] Axel Falck
And the "unlock tables" does not work any more into phpmyadmin GUI and it's OK with SQL command line with mysql under Ms-DOS windows
[6 Mar 10:52] Axel Falck
Same issues with phpmyadmin 5.0.1 the latest available !
[6 Mar 14:23] Axel Falck
Same issues with phpmyadmin 4.9.3 (Maria DB 10.1.4)

it's really a bug into phpmyadmin parser

URGENT TO FIX PLEASE
[6 Mar 16:00] MySQL Verification Team
Hi Axel,

phpmyadmin is not our product, please report a bug here:
https://github.com/phpmyadmin/phpmyadmin/issues

The only thing I can recommend is to use MySQL Workbench:
https://dev.mysql.com/downloads/workbench/

kind regards
Bogdan
[6 Mar 16:32] Axel Falck
Oups ...Sorry

thanks Bogdan