Even though this post is not directly related with the world of data science, it is one of those rare cases when a post is well deserved to be written in case it can save somebody else's life, just like in my case. A few days ago, I went into a big trouble, because (silly me) in a rare case of overconfidense, I didn't write down a root's passwords for a new DB I was working on, again, silly me. After review a few pages in Google, I found there was no a very straight forward solution to accomplish this task, so I had to mix and try a few suggested solutions (bibliography below), like this: 1. In Windows, open a command line, using admin privilegies. 2. Navigate through the folder path till you reach MariaDB's bin folder, in my case it was: C:\Program Files\MariaDB 10.3\bin 3.Stop MySQL service, in case it's still running: net stop mysql 4.Then move to the data folder: cd .. cd data 5. And modify the my.ini file: notepad my.ini 6. Right below the ...
Don't just hit the data, smash it!