It is sometimes useful to have a log of queries run on the MySQL/MariaDB database. Here's how to do it!
Should I use MySQL or MariaDB? That is probably the question in your mind right now.
Since the Docker has become a popular DevOps tools, you'll probably need to know how to run MySQL inside a Docker container.
Sometimes your first choice doesn’t always work out. So where do you look?
For security reasons, it is generally better to create and handle data as specific MySQL users.
You can create a MySQL database programmatically, but here's how to do it via the GUI.
If you are running a Linux server with MySQL, you can simply use the terminal to create a database.
Here I'm going to explain the native methods that are used to generate the backup of the MySQL database.