Python allows you to rename multiple files in directory. Here are the steps to do it.
Python Script to Load Data in MySQL
Python allows you to load data into databases and run SQL queries. Here is the python script to load data in MySQL.
NGINX Pass Headers from Proxy Server
How to Populate MySQL Table with Random Data
How to Get Query Execution Time in MySQL
It is good to keep track of query execution time of SQL queries in MySQL. Here is how to get query execution time in MySQL.
How to Get File Size in Python
How to View Active Connections Per User in MySQL
Sometimes database administrators need to view active connections per user in MySQL. Here are the steps to do it.
How to Show All Open Connections to MySQL Database
Sometimes you may need to view all open connections to MySQL database. Here is how to show all open database connections to MySQL database.
How to Revoke Privileges for Users in MySQL
Sometimes you may need to revoke privileges for users in MySQL. Here is how to revoke user privileges in MySQL.
How to Show Users With Access to MySQL Database
Sometimes database administrators need to find out which users have access to MySQL database. Here is how to show users with access to MySQL database.