I need to use a permenent table instead of temporary but I still need the table's data to be private to the connection
Dynamically create a table name of 

CONCAT("T_", CONNNECTION_ID())


With that, create the table.  (You cannot use "binding" to do so; you must create the entire CREATE TABLE string.)