Posts

Showing posts with the label windows

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: 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. ...

Windows Command Prompt Tricks You Probably Don’t Know

1. Send a Command’s Output to the Clipboard Note: This will work for any command. Without doing copy and paste the output, We can send the output directly to the clipboard. ipconfig | clip 2. Open Command Prompt From a Folder Do you want to open the command promp within a folder from explorer ? All you have to do is hold shift while right  clicking on a folder and the option will appear in the context menu. 3. Command History We can view our past command  i,e using doskey command. doskey /history 4. Drag and Drop Files to Change the Current Path Another neat trick if you are not a fan of opening a command prompt from the context menu is the ability to drag and drop folders onto the prompt and have it automatically enter the path of the folder. 5. Run Multiple Commands In One Go Want to run multiple command at once?  You can do this by linking them with double ampersands. ipconfig && netstat