Sometimes database administrators need to view active connections per user in MySQL. Here are the steps to do it.
How to View Active Connections Per User in MySQL
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 Enable SSL for MySQL in Windows
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.