Basic Question

[Dingo]

Hey folks.

I'm trying to clean up a couple databases listed in phpMyAdmin that are not shown as databases with DA. One being test - and another just a separate test DB I created from within phpMyAdmin.

Problem is I can't find a way that the system will let me "drop" these databases. Within the MySql query window I type "drop database test;" and get a window that says ' "drop database" statements are disabled'

Peculiar - I can't figure out what I'm doing wrong here. I'm a bit of a novice in both mysql and phpmyadmin - but searching Google didn't seem to help.

Thanks :)

[Nick]

Originally posted by Dingo@Jan 21 2005, 09:30 PM
Hey folks.

I'm trying to clean up a couple databases listed in phpMyAdmin that are not shown as databases with DA. One being test - and another just a separate test DB I created from within phpMyAdmin.

Problem is I can't find a way that the system will let me "drop" these databases. Within the MySql query window I type "drop database test;" and get a window that says ' "drop database" statements are disabled'

Peculiar - I can't figure out what I'm doing wrong here. I'm a bit of a novice in both mysql and phpmyadmin - but searching Google didn't seem to help.

Thanks :)

Quoted post


Open a helpdesk ticket @ http://helpdesk.hostpc.com

[Dingo]

Originally posted by Nick@Jan 21 2005, 11:25 PM

Open a helpdesk ticket @ http://helpdesk.hostpc.com

Quoted post


Ok but let me first understand something Nick...

Do we lack permission to kill a db within phpMyAdmin - and can only do it for databases listed within the DA DB section? (B/c I have two that aren't listed there - one being test which I understand is standard, and one being one I created within phpMyAdmin)

Thanks :)

[starfighter]

Originally posted by Dingo+Jan 22 2005, 08:28 AM--><div class='quotetop'>QUOTE(Dingo @ Jan 22 2005, 08:28 AM)</div><div class='quotemain'><!--QuoteBegin-Nick@Jan 21 2005, 11:25 PM

Open a helpdesk ticket @ http://helpdesk.hostpc.com

Quoted post


Ok but let me first understand something Nick...

Do we lack permission to kill a db within phpMyAdmin - and can only do it for databases listed within the DA DB section? (B/c I have two that aren't listed there - one being test which I understand is standard, and one being one I created within phpMyAdmin)

Thanks :)

Quoted post
[/b][/quote]
No,
You can drop databases you own, Nick asked you to open the ticket because there is a good chance that there is a permissions problem. Yes all databases need to be created within DA to have the proper permissions set.

[Dingo]

Originally posted by starfighter@Jan 22 2005, 12:12 PM

No,
You can drop databases you own, Nick asked you to open the ticket because there is a good chance that there is a permissions problem. Yes all databases need to be created within DA to have the proper permissions set.

Quoted post


Ok so the proper thing to do is to create mysql databases within DA - great. Thanks.

I assume then that database design can be either done from within php scripts - or within phpMyAdmin? (E.g, if I have a developer doing some very basic design work - who doesn't need my account access - he can create tables as needed via php scripts, or he can ask me to do it within phpMyAdmin)

I think I have it correct now?

[D9r]

I assume then that database design can be either done from within php scripts - or within phpMyAdmin? (E.g, if I have a developer doing some very basic design work - who doesn't need my account access - he can create tables as needed via php scripts, or he can ask me to do it within phpMyAdmin)
Of course. That is correct sir. B)