Getting Lock wait timeout exceeded try restarting transaction even though I m not using a transaction

Error :

I'm running the following MySQL UPDATE statement:

mysql> update customer set account_import_id = 1; 
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Solution :

Let's see the list of the current processes, one of them is locking your table(s):-
 mysql> show processlist;

Finally, kill one of these processes:-

 mysql> kill <process id>