WEC Posted June 6, 2007 Report Share Posted June 6, 2007 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? Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted June 6, 2007 Report Share Posted June 6, 2007 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? Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
WEC Posted June 6, 2007 Author Report Share Posted June 6, 2007 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. Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted June 6, 2007 Report Share Posted June 6, 2007 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.... Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
metaltailz Posted June 6, 2007 Report Share Posted June 6, 2007 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. Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted June 6, 2007 Report Share Posted June 6, 2007 Um, thats the same thing WEC said, lol. oO Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
metaltailz Posted June 7, 2007 Report Share Posted June 7, 2007 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 =) Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted June 7, 2007 Report Share Posted June 7, 2007 Who cares... its alright, lol. And i feel you... when i was in high school they used to block websites like crazy, lol. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
Elminster Posted June 8, 2007 Report Share Posted June 8, 2007 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 Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted June 8, 2007 Report Share Posted June 8, 2007 It will... 3.5 is around the corner... Quote Best Regards Olajide Olaolorun The Uniform Server Development Team 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.