mysqladmin -u root -p -i 1 processlist
-u username
-p you will be promted for a password
-i 1 interval one second
mysqladmin -u root -p -i 1 processlist
-u username
-p you will be promted for a password
-i 1 interval one second
mysql>show variables like '%event%'; +---------------------------------------------------+-------+ | Variable_name | Value | +---------------------------------------------------+-------+ | event_scheduler | OFF | | performance_schema_events_waits_history_long_size | 10000 | | performance_schema_events_waits_history_size | 10 | +---------------------------------------------------+-------+ mysql>SET GLOBAL event_scheduler = 1; mysql>use database; mysql>CREATE EVENT flush_query_cache ON SCHEDULE EVERY 1 HOUR DO FLUSH QUERY CACHE;
# /etc/init.d/mysql stop
# mysqld_safe –user=mysql –skip-grant-tables –skip-networking &
# mysql -u root mysql
#mysql> UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=’root’;
#mysql> FLUSH PRIVILEGES;
#mysql> quit
# /etc/init.d/mysql restart