aspose file tools
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

Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
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: 32088

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]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: can't access database in PHPMyAdmin