MySQL Server Helpful Functions

October 31, 20191 min read

Show connections that your MySQL server has

show status like 'Conn%';

show status like '%onn%';

Show all users of your MySQL server

select * from mysql.user;

select host, user, password from mysql.user;

Describe a table

desc user;