You are asking for some server configuration settings to limit the maximum number of rows returned by all queries. That is, select * from mytable
will return maximum x number (x is set in global server configuration) or rows even there are many more rows in the table.
Unfortunately, this is not possible in standard distributions of MySQL. You can set limits on maximum queries per hour, even what operations a user can do in server. But, limit of number of rows in query result cannot be set globally.
However, you can get the MySQL community edition source code and add a configuration for global query result limit.
Also, if you are using some kind of connector to connect to MySQL (for example, if you are connecting to MySQL from .NET), you can leave the server as is but modify the connector code and add your desired limiting configuration option there.