cancel
Showing results for 
Search instead for 
Did you mean: 

How do I grant myself ALTER privileges?

griffog
Dabbler
Posts: 16
Registered: ‎04-08-2007

How do I grant myself ALTER privileges?

I have a Wordpress site running and have been advised to change prefixes on the tables as a security measure.
When I try (using the WP-Database Securtity plug-in) I get this error:
Quote
WordPress database error There is no such grant defined for user 'xxxxxx' on host 'humbug' for query SHOW GRANTS FOR 'xxxxxxx'@'humbug' made by do_action, call_user_func_array, mrt_sub3

I can see that I need ALTER rights but am confused as to how/where I make that change?