In the database mysql, user table, i had to to change the field Drop_priv for user root from N to Y in order to get rid of error message:

 

DROP command denied to user 'root'@'localhost'

 

Seems that N is a wrong default setting for this field?

This has been pinned!

 

To move on, that should only say that if you are trying to drop a table in the mysql database though, right?

Initially the error came up when trying to install PHP-Fusion CMS.

 

Then tried to drop all of the PHP-Fusion tables via phpMyadmin, but got the same error message in phpMyadmin.

 

Changed N to Y to get rid of the error message both when running the PHP-Fusion installation and when trying to drop tables in phpMyadmin in general.

hmm.. ok... I think i mistakenly caused that and forgot to fix it when i was trying to fix the privilege error... error for an error....

Well, if you try to add the drop command like you would normally by editing privleges through phpMyAdmin you can't.

 

To get around this little bug, start the server, start MySQL. Open phpMyAdmin, you should see a bar on the side with a drop down menu. Click on it and select the database mysql, scroll down until you see a table called user, then click the browse button. You will then see a list of all the users, click on edit next to root. You will then see a list of all the privleges available to that user, just change the value of Drop_priv to yes.

 

You should now be able to use the drop command in MySQL.

Um, thats the same thing WEC said, lol. oO

Well, I was at school and we aren't technically supposed to be on any sort of bulletin board system, so I just quickly read the first post and wrote mine.

 

Sorry about that =)

Who cares... its alright, lol.

 

And i feel you... when i was in high school they used to block websites like crazy, lol.

This really should be fixed in the download package. It took me quite some time to remember that I just changed von 3.3 to 3.4

It will... 3.5 is around the corner...