You must have at least SELECT privilege (as a global privilege or a SCHEMA/COLUMN privilege, to be able to see any data.
More information on the MySQL privilege system can be found here
If the database is hosted at an ISP/hosting provider it is likely that you must use some web-based "Control Panel" application to set up user privileges.