vigiw Posted December 1, 2006 Share Posted December 1, 2006 Hello, I am running MySQL on my home computer, a Windows XP Pro. I am using Navicat and was changing users and permissions to secure the database--then, somehow I had a user with all privileges, and the rest without any, and this user connected to a no-ip.com address because I was trying something out, and it didn't work out so well. Now I cannot login to any of the connections of the database... So my question is, is there a way to undo this--or how do I create a new database or something on my PC so I can start over, this time, with a working connection? Thanks! Quote Link to comment Share on other sites More sharing options...
gluck Posted December 1, 2006 Share Posted December 1, 2006 You will find your answers here. You can start MySQL with ignoring the user tables.http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Quote Link to comment Share on other sites More sharing options...
vigiw Posted December 1, 2006 Author Share Posted December 1, 2006 Hi gluck, Thanks for your help! ;D Will this work if my host is wrong, like I said, and not local host? That is the reason I cannot access.. If so, for the file including SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');should I change localhost to my non-working no-ip.com host -- or if I type localhost, will it make it so I can access with localhost?Thanks again! 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.