MySQL/MariaDB are popular Databases, which are often used for data scraping, because they can handle a lot of INSERTs in a short time. In this post I will show you how to add a new user and set the permissions to access a database.

I had to implement a web scraping script, which fetches data from a website on a given interval. The problem was that sometimes the values were updated by the data provider and so some values in my scraping database had to be reloaded and updated as well.