File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes can't access database in PHPMyAdmin Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "can Watch "can New topic

can't access database in PHPMyAdmin

Ken Ng

Joined: Feb 14, 2004
Posts: 26
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?
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

Did restarting the mySql process (or the whole machine) help?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: can't access database in PHPMyAdmin
jQuery in Action, 3rd edition