Friday, January 13, 2017

How to uinstall MySQL completely from Windows OS?

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:

  1. Stop MySQL services and remove services by executing below command in command prompt (Start it as Administrator)
    1. Net stop MySQL
    2. Sc delete MySQL
  2. Uninstall MySQL program from the control panel.
  3. #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.)
    1. C:\Program Files\MySQL
    2. C:\Program Files (x86)\MySQL
    3. C:\ProgramData\MySQL
    4. C:\Users\<USERNAME>\AppData\Roaming\MySQL
  4. Restart your instance and install it again.
Happy coding..!!!

1 comment:

  1. Are you a skilled and impressive person who is looking to grow professionally with an international group be a part of us as we break new floor in one of many world’s most fast-moving industries. The KCGP provides a helpline that anyone in South Korea can name, 24 hours a day, 365 days days|one year} a yr, for themselves or on behalf of another person. Even if the location is simply offered in English, numerous browser-based instruments can immediately translate textual content into Korean for you. Other revered licence-issuing authorities additionally exist, and whereas they might not garner the identical stage of respect as the 2 talked about above, they are greater than satisfactory all the identical. Such authorities 카지노사이트 embrace the Gibraltar Gaming Authority and the government-approved issuers of licences in Curaçao.