1

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip'  Identified by "密码" WITH GRANT OPTION;

1

mysqladmin -u sky -ppwd -h localhost ping

1

mysqladmin -u sky -ppwd -h localhost status

1

mysqladmin -u sky -ppwd -h localhost processlist

1

mysql -u root -ppwd -BNe "select host,count(host) from processlist group by host;" information_schema

1

mysql -e"SHOW STATUS LIKE '%uptime%'"|awk '/ptime/{ calc = $NF / 3600;print $(NF-1), calc"Hour" }'

1

mysql -u root -ppwd-e 'select table_schema,round(sum(data_length+index_length)/1024/1024,4) from information_schema.tables group by table_schema;'

1

mysql -u <user> --password=<password> -e "SHOW COLUMNS FROM <table>" <database> | awk '{print $1}' | tr "\n" "," | sed 's/,$//g'

1

mysql -u user-name -p password < script.sql

1
2

ps -ef | grep "mysqld_safe" | grep -v "grep"
ps -ef | grep "mysqld" | grep -v "mysqld_safe"| grep -v "grep"

1

mysql -u root -ppwd -e 'show status'

1

mysqlcheck -u root -ppwd --all-databases

1
2

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Questions"'
mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Queries"'

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Key%"'

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Innodb_buffer_pool_read%"'

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Qcache%"'

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Open%"'

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Thread%"'  

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "%lock%"'

1

mysql -u root -ppwd -e 'SHOW SLAVE STATUS'

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Created_tmp%"'

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Binlog_cache%"'

1

mysql -u root -ppwd -e 'SHOW /*!50000 GLOBAL */ STATUS LIKE "Innodb_log_waits'