Article ID: 3299, created on Nov 30, 2007, last review on May 10, 2014

  • Applies to:
  • H-Sphere

Resolution

In this example database is unixtes_test23 1. Log in to the control panel server as root Run: #su - cpanel -c 'psql hsphere' hsphere=# select * from mysqldb where db_name = 'unixtes_test23'; id | parent_id | db_name | db_description | locked_by ------+-----------+----------------+----------------+----------- 2180 | 1113 | unixtes_test23 | test23 | 2183_58 (1 row) hsphere=# begin; BEGIN hsphere=# update mysqldb set locked_by=NULL where id=2180; UPDATE 1 hsphere=# commit; COMMIT hsphere=# select * from mysqldb where db_name = 'unixtes_test23'; id | parent_id | db_name | db_description | locked_by ------+-----------+----------------+----------------+----------- 2180 | 1113 | unixtes_test23 | test23 | (1 row) 2. Restart control panel software 3. Go to user ControlPanel Databases=> MySQL => MySQL and delete database unixtes_test23

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF