>>> conn = pymysql.connect(host='10.1.1.216',port=3306, user='linxz_genome', db='linxz123')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/nfs3/onegene/user/group1/linxingzhong/workspace/flask/env/lib/python2.7/site-packages/pymysql/__init__.py", line 90, in Connect
    return Connection(*args, **kwargs)
  File "/nfs3/onegene/user/group1/linxingzhong/workspace/flask/env/lib/python2.7/site-packages/pymysql/connections.py", line 688, in __init__
    self.connect()
  File "/nfs3/onegene/user/group1/linxingzhong/workspace/flask/env/lib/python2.7/site-packages/pymysql/connections.py", line 906, in connect
    self._request_authentication()
  File "/nfs3/onegene/user/group1/linxingzhong/workspace/flask/env/lib/python2.7/site-packages/pymysql/connections.py", line 1114, in _request_authentication
    auth_packet = self._read_packet()
  File "/nfs3/onegene/user/group1/linxingzhong/workspace/flask/env/lib/python2.7/site-packages/pymysql/connections.py", line 981, in _read_packet
    packet.check_error()
  File "/nfs3/onegene/user/group1/linxingzhong/workspace/flask/env/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
    err.raise_mysql_exception(self._data)
  File "/nfs3/onegene/user/group1/linxingzhong/workspace/flask/env/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, u"Access denied for user 'linxz_genome'@'10.1.1.215' (using password: NO)")

mysql> GRANT ALL on *.*  to 'linxz_genome'@'10.1.1.216' IDENTIFIED BY 'linxz123' WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'linxz_genome'@'%' (using password: YES)