How to clear cache?

I was wondering how do you clear database cache..?

I have no idea what so ever so please fill me in hehe

 

what kind of DB system you have? mysql/mssql other?

 

mysql database system

 

The RESET QUERY CACHE or FLUSH TABLES statement removes all query results from the query cache.

 

MySQL said: Documentation
#1227 - Access denied; you need the RELOAD privilege for this operation

im getting that messege how do i give myself premissions? its my server so i just need to know how to do thanks

 

If it's your own server you should grant all permission to yourself.

So, if your mysql username is "root" and your hostname is "localhost" you can run the query below to grant the user root all permissions.

REVOKE ALL PRIVILEGES ON * . * FROM 'root'@'localhost';

GRANT ALL PRIVILEGES ON * . * TO 'root'@ 'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

Code (markup):

 

only as admin you can clear mysql cache

 

where do i do that wing at the ssh command?

 

Yes, either SSH or PhpMyAdmin or similar..

From the manual at hxxp://dev.mysql.com/doc/refman/4.1/en/grant.html

In short, to use GRANT to set priviliges you must be the rootusersuperbazookaadmin.