MySQL Server Helpful Functions

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;

Subscribe To Our Newsletter
You will receive our latest post and tutorial.
Thank you for subscribing!


Leave a Reply

Your email address will not be published. Required fields are marked *