ERROR 1099 (HY000): Table ‘TABLENAME′ was locked with a READ lock and can’t be up dated

This error occurs when you try to insert data into a table that has been locked for reading only. Lock table: mysql> LOCK TABLES TABLEproducts READ; Query OK, 0 ROWS affected (0.00 sec) Trying to insert into TABLEproducts creates the error: INSERT INTO TABLEproducts(comment) VALUES(’READ LOCK BY MYSELF’); Error: ERROR 1099 (HY000): Table ‘TABLEproducts′ was […]
Continue reading…

Enjoyed this post? Share it!

 
 

ERROR 1142 (42000): SHOW VIEW command denied to user ‘test’@’localhost’ for table ‘system’

This error(ERROR 1142 (42000): SHOW VIEW command denied to user ‘test’@’localhost’ for table ‘system’) occurs when users donot have sufficient privileges to view the syntax of a view definition. The view could have been created using the SQL SECURITY INVOKER clause. A root user will not get this error. Error occurs when this statement is […]
Continue reading…

Enjoyed this post? Share it!

 
 

ERROR 1356 (HY000): View ‘viewname’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

This MySql (error ERROR 1356 (HY000): View ‘viewname’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) occurs when a user tries to read data from a view that has been protected using the SQL SECURITY INVOKER clause while creating the view. Creating view using the SQL SECURITY […]
Continue reading…

Enjoyed this post? Share it!

 
 

ERROR 1142 (42000): ANY command denied to user

This error is generally experienced when you try to create a view on tables where the user does not have permissions.For example, the user has permissions to create views only in a specific schema. A normal user trying to run this command will get the ERROR 1142 (42000): ANY command denied to user… CREATE VIEW […]
Continue reading…

Enjoyed this post? Share it!