joaopm33

Hello,

 

As dumb as it may sound, I think I created a lot of connections with my DB without closing them. I am trying to Kill them but i cant see the connections. When I type :

SHOW PROCESSLIST

I get two processes:

 

  Id User Host db Command Time State Info  Termina 17453 joaopm33 localhost joaopm33_Mush_Instagram Query 0 starting SHOW PROCESSLIST  Termina 17454 joaopm33 localhost NULL Sleep 0   NULL                                  

When trying to kill them i get an unknow id error.

 

I should see 4 connections once I am getting the error:

mysql.connector.errors.ProgrammingError) 1203 (42000): User joaopm33_joaopm33 already has more than 'max_user_connections' active connections

What am I doing wrong here (beside opening all those connections in the first place)

 

 

Tks a lot , i guess it solved it!

Hi Admin, can you please let me know how to install python libraries in my server?

 

Your cPanel username: joaopm33

Your main domain: http://joaopm33.heliohost.us

The server that you are on: johnny

Python version: 3.7

Module(s) that you need installed:

• instaloader
• mysql

 

I am trying to connect to my helionet mysql db to read and write tables.

 

I firstly import the sqlalchemy create engine function:

from sqlalchemy import create_engine

Then, when i create my connection with the db with:

engine = (create_engine('mysql+mysqlconnector://<user>:<password>@<host>/<database>').connect())

I get an Error:

No module named 'mysql'

The exact same code works fine accessing the db from my local environment, so i guess its a library prooblem.

Can you help me? Thanks in advance!