kreut Posted August 16, 2011 Share Posted August 16, 2011 Hello! Somehow (as if by magic...) I changed my local testing environment MAMP root permissions so that I could no longer DROP tables. Well, now I'd like to DROP tables, but it won't let me change my root user (permission denied/password needed). Since I'm not asked for a password in the first place I'm not quite sure how to do this, nor what password to use. Any help would be appreciated...I'd hate to have to reinstall it all. Thanks so much, Eric Quote Link to comment Share on other sites More sharing options...
fenway Posted August 16, 2011 Share Posted August 16, 2011 if you have root access, skip the grants. Quote Link to comment Share on other sites More sharing options...
kreut Posted August 16, 2011 Author Share Posted August 16, 2011 Hmmm..I'm not sure what you mean by "skip the grants". If it helps, the exact error that I get is: "DROP command denied to user 'root'@'localhost' for table 'examples'" Isn't this saying that as a root user I don't have the access? This doesn't really make sense to be because I thought that the root user was the "superuser". If you could clarify your answer, I'd appreciate it. Thanks! -Eric Quote Link to comment Share on other sites More sharing options...
fenway Posted August 16, 2011 Share Posted August 16, 2011 --skip-grants is an option to the mysql client. Quote Link to comment Share on other sites More sharing options...
kreut Posted August 16, 2011 Author Share Posted August 16, 2011 Thanks! Quote 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.