luciferjack/python-mysql-pool

If you use python and mysql, maybe one day you want it. base on pure mysql-connector ,auto manage connection and support 【no pool connect 、fixed 、dynamic pool】. Now used inBaidu poi off-line calculation system . ------------------- Open your favorite Terminal and run the modlue

python-mysql-pool's Issues

can't multiply sequence by non-int of type 'tuple'

return "VALUES " + ", ".join([items_sql] * num_values)
TypeError: can't multiply sequence by non-int of type 'tuple'

Django-pool-showcase

use PyMysqlPool example img show
show case

raise errors.get_exception(packet) django.db.utils.DatabaseError

raise errors.get_exception(packet)
django.db.utils.DatabaseError: Incorrect datetime value: '2017-09-21 09:51:12.769000+00:00' for column 'applied' at row 1
fixed:

doc page not found

http://PyMysqlPool.readthedocs.io/
broken url ?

is it not supporting to fetchOne method

Shall we use the fetchOne method and next method in it?

[Question] Unable to connect to MySQL DB from remote machine:mysql.connector.errors.DatabaseError: 1130 (HY000): Host 'machine.xxx.xxx.com' is not allowed to connect to this MySQL server

I am new to this world so I do anything wrong please guide me.

I am using MySQL DB server 8.0 and trying to connect from a remote machine using below Python code:
import mysql.connector mydb = mysql.connector.connect(host='10.xx.xxx.xx', user='dummyuser', passwd='dummypwd') myCursor = mydb.cursor() myCursor.execute("show databases") for i in myCursor: print(i)

I get below error:
mysql.connector.errors.DatabaseError: 1130 (HY000): Host 'xxxxxx-xxx-xxx.xxx.xxx.com' is not allowed to connect to this MySQL server

I checked on the net but nothing seems to work for me can you please guide how can I get this resolved.

it doesn't support python3.5

it use MySQLdb to connect mysql, but not support python3.5 and python3.6 and more.

Lib is printing all logs into syslog file

Hi Team,
if i used that package, it's printing all python packages print, debug, warning and notice into syslog which is increasing syslog file in GB's in few minutes.