mariadb – MySQL client (Windows) and MySQL Server (Ubuntu VM) showing different result


I am working for Query profiling. On MySQL Client I executed these three statements

SET PROFILING=ON;
SELECT COUNT(*) FROM EMP;
SHOW PROFILES;

It gives me desired result as :

Query_ID    Execution_Time      Query_Statement
1           0.01234             SELECT COUNT(*) FROM EMP;

Now I moved to MySQL Server and want to check more information about this Query execution. And Server show Empty set.

can anyone please help me how I can get results on both terminals to check profile information for each query.

SELECT * FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 1;