MySQL Bugs: #98833: Lock tables does not work from phpmyadmin.... But of from SQL Client as SQLyog

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

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

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

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 ???

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

Same issues with phpmyadmin 5.0.1 the latest available !

Same issues with phpmyadmin 4.9.3 (Maria DB 10.1.4)

it's really a bug into phpmyadmin parser

URGENT TO FIX PLEASE

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

Oups ...Sorry

thanks Bogdan