Mysql 4 - Limiting user resources

[AlaskanWolf]

anyone around here know how to integrate these new features?

http://www.mysql.com/doc/en/User_resources.html

 

[jackal]

You can follow this thread if you want.
http://www.vbulletin.com/forum/showthread.php?postid=439985#post439985

there response

Run the script mysql_fix_privilege_tables to add new privileges and features to the MySQL privilege tables.
http://www.mysql.com/doc/en/Upgrading-from-3.23.html

May help you

 

[SoftmegUK]

lol u sure AlaskanWolf on these forums and webhost on them arnt the same person... posts r exactly the same lol.... just my thought....

 

[jackal]

LoL no they are different people I know both of them.

 

[AlaskanWolf]

Hey Meg, please keep the posts on track. Unless you got some helpful hints, please.....

I asked how you would go about integrating the features such as max user connections per hour stuff, i have no idea, it tells you about GRANT stuff, no clue though, since i am not a mysql (anything..guru...jock...etc..)


I need a step by step instructions on how you would add these globally, MySQL site...nothing gives any examples, which is what i am looking for

 

[eva2000]

Originally posted by AlaskanWolf
Hey Meg, please keep the posts on track. Unless you got some helpful hints, please.....

I asked how you would go about integrating the features such as max user connections per hour stuff, i have no idea, it tells you about GRANT stuff, no clue though, since i am not a mysql (anything..guru...jock...etc..)


I need a step by step instructions on how you would add these globally, MySQL site...nothing gives any examples, which is what i am looking for

hi Gary maybe http://www.vbulletin.com/forum/showthread.php?postid=440117#post440117 would help

i haven't used them myself... as i'd hate for a web host to be so restrictive on a mysql user a/c as there are better ways to manage mysql performance and usage in general

mysql.com doesn't give any examples of how to set values for MAX_QUESTIONS, MAX_UPDATES, MAX_CONNECTIONS though... which is confusing me

 

[AlaskanWolf]

I will also post in WHT and see if anyone there has any suggestions or examples.

It would be great to have a example for other hosts that may want to add such