my dog learned polymorphism
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
Author

can't access database in PHPMyAdmin

Ken Ng
Greenhorn

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
Marshal

Joined: May 26, 2003
Posts: 32481
    
214

Ken,
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
 
Have you checked out Aspose?
 
subject: can't access database in PHPMyAdmin
 
It's not a secret anymore!