softlab Posted February 14, 2015 Share Posted February 14, 2015 Hi. How can I drop a database I have created? In phpmyadmin I do not have drop permissions; in mysql manager I do not see the database I want to drop, but if I try to create a database with that name it says it exists. Thanks Quote Link to comment Share on other sites More sharing options...
wolstech Posted February 14, 2015 Share Posted February 14, 2015 An admin needs to drop it for you. I really wish we would just enable drop in PMA. This happens a lot... I havent tried it, but you might also be able to activate remote MySQL and use something like MySQL workbench from your PC to drop it. Quote Link to comment Share on other sites More sharing options...
softlab Posted February 14, 2015 Author Share Posted February 14, 2015 Mi home domain is softlab.heliohost.org, should I enable that remote host? And how can I then connect with it? Which credentials should I use? Quote Link to comment Share on other sites More sharing options...
wolstech Posted February 15, 2015 Share Posted February 15, 2015 On the remote MySQL page in cpanel, enter a % sign to enable it. Connect using johnny.heliohost.org (or stevie.heliohist.org if youre on that server) as the host. Use your cpanel user/password for credentials. Quote Link to comment Share on other sites More sharing options...
softlab Posted February 15, 2015 Author Share Posted February 15, 2015 Hi. I managed in connecting remotely to MySql, but cannot create the database. If I connect with MyPhpAdmin I see a database named "parrocchia", and I cannot drop it. If I connect remotely to MySql I do not see that database at all, but if I try to create a database named "parrocchia" I get an error message saying "Access denied for user 'softlab'@'%' to database 'softlab_parrocchia'. Quote Link to comment Share on other sites More sharing options...
softlab Posted February 20, 2015 Author Share Posted February 20, 2015 Is there anyone who can help me? I summarize my problem:- in phpMyAdmin I see a database named 'softlab_parocchia'; when I try to execute a drop command, I am told it's disabled- in remote access I do not see that database; when I try to create it, I am told that it exists.How can I do? Quote Link to comment Share on other sites More sharing options...
yashrs Posted February 20, 2015 Share Posted February 20, 2015 The best thing you could do is create a database with different name, and let that database be as it is. Quote Link to comment Share on other sites More sharing options...
softlab Posted February 21, 2015 Author Share Posted February 21, 2015 I don't know what has happened, but now I see the database I did not see before, and can operate on it. Thank you anyway. Quote Link to comment Share on other sites More sharing options...
yashrs Posted February 21, 2015 Share Posted February 21, 2015 Oh, thats great. Let us know if you have any other queries. Quote Link to comment Share on other sites More sharing options...
johannsdiary Posted March 5, 2015 Share Posted March 5, 2015 I have the same problem, in short:1. I created a database named, johann_ttrss2. I deleted this database, johann_ttrss, on MySQL page in cpanel. (because not knowing InnoDB issue, and trying deleting and then recreating)3. Try to recreate this database with the same name, johann_ttrss, but encountered already exists problem while this is no this database in MySQL page in cpanel.4. When I navigated to phpmyadmin page, i finally find this already deleted database, namely, johann_ttrss.5. After searching this forum, I found this post and followed what Moderators said in #4 (floor of this post), but encountered the same problem in #5. My question now is: How did you manage to operate on it according to #8?Can you help me? By the way, how to deal with the InnoDB problem? <p>And when i try to delete one exit database in terminal, i encountered the following message:</p><p> </p><div>mysql> drop database johann_tinyrss;</div><div>ERROR 1010 (HY000): Error dropping database (can't rmdir './johann_tinyrss', errno: 39)</div><div> </div><div>Note: johann_tinyrss is another database that i create instead of johann_ttrss</div> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.