I don't think there is an option available to limit mysql usage for single domain...but you can tweak your /etc/my.cnf file to limit connections, quearies..etc for server wide..
AssistanZ - Beyond Boundaries... Cloudstack Consultancy / 24x7 Web Hosting Support / 24x7 Server Management / Infrastructure Management Services Web & Mobile Apps Development / Web Designing Services / Php, Grails, Java Development
lets say i have user1 which i want to limit his mysql usage
can i creat a my.cnf file and put it in his /home/user1/ folder or i need to edit /etc/my.cnf file ?
also what will i have to put inside my.cnf file for limiting his usage ?
Originally posted by BizB now what exactly should i add ?
and how to make it for user1 and not just for all
You can add anything you want there.. It won't help the problem you're trying to solve.
It's already been pointed out twice that changes to the config file will be server wide changes.
If you want to restrict one specific user... you have to use the GRANT tables.
See above for an suggestion as to what exactly to type. But, you really should have a clue what it's going to do before hand... or pay someone who has a clue to do it for you. As the above might not do exactly what you want it to.