Friday 20 October 2017

mysql flush commands

List of all mysqladmin flush commands.


flush-hosts: Flush all information in the host cache.
flush-privileges: Reload the grant tables (same as reload).
flush-status: Clear status variables.
flush-threads: Flush the thread cache.

# mysqladmin -u root -pmypassword flush-hosts
# mysqladmin -u root -pmypassword flush-logs
# mysqladmin -u root -pmypassword flush-privileges
# mysqladmin -u root -pmypassword flush-status
# mysqladmin -u root -pmypassword flush-tables
# mysqladmin -u root -pmypassword flush-threads

Check MySQL Server is up and running


# mysqladmin -u root -p ping
Enter password:
mysqld is alive

No comments:

Post a Comment