Python allows you to load data into databases and run SQL queries. Here is the python script to load data in MySQL.
Python Script to Load Data in MySQL
MySQL
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 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.
How to Show User Permissions in MySQL
Sometimes you may need to show user permissions in MySQL. Here is how to show user permissions in MySQL.
How to Show All Users in MySQL
Sometimes you may need to list all user accounts or get list of user accounts. Here is how to show all users in MySQL.
How to Repair MySQL Databases & Tables
Sometimes you may need to repair MySQL databases & tables as they grow. Here is how to repair MySQL databases & tables.
How to Optimize MySQL Tables
Sometimes you may need to optimize MySQL tables to improve query speed and performance. Here is how to optimize MySQL tables.
How to Allow MySQL User from Multiple Hosts
Sometimes you may want to allow MySQL users from all hosts. Here are the steps to allow MySQL user from multiple hosts.