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. 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...