Phpmyadmin

[softlab]

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]

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]

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]

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]

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]

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]

The best thing you could do is create a database with different name, and let that database be as it is.

[softlab]

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]

Oh, thats great. Let us know if you have any other queries.

[johannsdiary]

I have the same problem, in short:

1. I created a database named, johann_ttrss

2. 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>