Jump to content

joaopm33

Members
  • Posts

    3
  • Joined

  • Last visited

joaopm33's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. 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 PROCESSLISTI 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 connectionsWhat am I doing wrong here (beside opening all those connections in the first place)
  2. Tks a lot , i guess it solved it!
  3. 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: instaloadermysql 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_engineThen, 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!
×
×
  • Create New...