Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE

Tempfiles, unlike normal data files are not listed in v$datafile or dba_data_files.

Instead query v$tempfile or dba_temp_files

SQL>SELECT * FROM v$tempfile; 

SQL>SELECT * FROM dba_temp_files; 
Labels:

How to fix: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

Open your terminal and type mysql -u root -p Enter your password. Hopefully your MySQL is logged in now.