• Post Reply Bookmark Topic Watch Topic
  • New Topic

can't access database in PHPMyAdmin  RSS feed

 
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Need Help!. I run a page executing SQL that locks a table. Then i execute a unlock statement.
In phpmyadmin, i found that i cannot access the table so i went to Home > show proceess > and kill some of the threats;
=> status SHOW TABLE STATUS FROM `my_db` is locked.

It still cannot work. I click the reload MySQL link, shut the mysql server and restart it. Now, the whole database cannot be loaded.

Any body knows how to unlock the entire database?
 
author & internet detective
Marshal
Posts: 37688
574
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ken,
Did restarting the mySql process (or the whole machine) help?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!