I was running some script which did some changes to my database and corrupted my root permission. Tried so many things but didn't work out.
Finally, I decided to uninstall the MySQL from my instance and install a new one but again it was not an easy job as MySQL stores file at the various locations that you have to removed manually before starting from the scratch.
Simple steps to uninstall MySQL:
Finally, I decided to uninstall the MySQL from my instance and install a new one but again it was not an easy job as MySQL stores file at the various locations that you have to removed manually before starting from the scratch.
Simple steps to uninstall MySQL:
- Stop MySQL services and remove services by executing below command in command prompt (Start it as Administrator)
- Net stop MySQL
- Sc delete MySQL
- Uninstall MySQL program from the control panel.
- #2 will uninstall the program but will not remove all the files from your machine which we have to do it manually.(Removing all files will remove existing database. Take the backup, if you need it in future.)
- C:\Program Files\MySQL
- C:\Program Files (x86)\MySQL
- C:\ProgramData\MySQL
- C:\Users\<USERNAME>\AppData\Roaming\MySQL
- Restart your instance and install it again.
Happy coding..!!!
No comments:
Post a Comment