Unable to count/Insert into database

I am a beginner trying to select data from a table with seemingly millions of records. I tried running the

select count(*) from MyTable;

It doesnt return any results and either takes forever or hangs.

And, I also tried selecting all the IDs alone from that huge table, and inserting into another database's table. Neither of the statements work.

Even the simple select * from MyTable; command doesn't work without setting limits. I assume this db contains millions of records, and I dont have any permissions to add or modify that database(like creating indexes) and stuff. I am clueless on what to do. Please help.