Enter into mysql prompt,
mysql > SELECT host, user, select_priv, update_priv FROM user WHERE user='teachers';
How to log MySQL slow queries:
# vi /etc/rc.d/init.d/mysqld
Find this line:
SAFE_MYSQLD_OPTIONS="--defaults-file=/etc/my.cnf"
change it to:
SAFE_MYSQLD_OPTIONS="--defaults-file=/etc/my.cnf --log-slow-queries=/var/log/slow-queries.log"
As you can see, we added the option of logging all slow queries to /var/log/slow-queries.log
Close and save mysqld.
touch /var/log/slow-queries.log
chmod 644 /var/log/slow-queries.log
Restart mysql
service myslqd restart
mysqld will log all slow queries to this file.