wood burning stoves 2.0*
The moose likes JDBC 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
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30116
    
150

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


[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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: can't access database in PHPMyAdmin
 
Similar Threads
How to access a database over a network
code or server problem ?
connecting JSP(resin) to MYSQL with out root
phpMyAdmin or something like it.
Detect if table exists