softlab Posted February 14, 2015 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
wolstech Posted February 14, 2015 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.
softlab Posted February 14, 2015 Author 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?
wolstech Posted February 15, 2015 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.
softlab Posted February 15, 2015 Author 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'.
softlab Posted February 20, 2015 Author 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?
yashrs Posted February 20, 2015 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.
softlab Posted February 21, 2015 Author 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.
yashrs Posted February 21, 2015 Posted February 21, 2015 Oh, thats great. Let us know if you have any other queries.
johannsdiary Posted March 5, 2015 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>
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now