Wiki

by yszheda

View project onGitHub

MySQL

Command

http://stackoverflow.com/questions/5131931/connecting-to-mysql-from-the-command-line

http://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server

http://stackoverflow.com/questions/3736407/mysql-server-port-number

http://oracledba.bigresource.com/Develop-shell-script-which-will-do-monitoring-of-alert-log-daily-kMqxvZycQ.html

http://stackoverflow.com/questions/20033648/how-to-run-mysql-command-on-bash

http://mysqlmymon.com/

http://www.inmotionhosting.com/support/website/server-usage/create-mysql-query-monitoring-bash-script

Python

http://www.runoob.com/python/python-mysql.html

http://skhohlov.blogspot.jp/2013/01/small-python-script-for-monitoring.html

http://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python

http://stackoverflow.com/questions/758819/python-mysqldb-connection-problems

http://stackoverflow.com/questions/2314920/django-show-log-orm-sql-calls-from-python-shell

https://github.com/shoma/mysqlmonitor/blob/master/src/mysqlstatus.py

https://support.serverdensity.com/hc/en-us/articles/201013827-MySQL-monitoring-Linux-Mac-and-FreeBSD

http://zetcode.com/db/mysqlpython/

http://stackoverflow.com/questions/775296/python-mysql-with-variables

http://stackoverflow.com/questions/12867140/python-mysqldb-get-the-result-of-fetchall-in-a-list

Problems

Lost connection to MySQL server at 'reading initial communication packet'

http://www.bramschoenmakers.nl/en/node/595.html

http://stackoverflow.com/questions/5755819/lost-connection-to-mysql-server-at-reading-initial-communication-packet-syste

http://stackoverflow.com/questions/3578147/mysql-error-2013-lost-connection-to-mysql-server-at-reading-initial-communic

ERROR 1130 (HY000): Host is not allowed to connect to this MySQL server

一般原因:

  • 限制远程登录
  • 限制ip

http://www.cnblogs.com/chutianyao/archive/2011/12/28/2304332.html

http://blog.csdn.net/leroy008/article/details/16116847