How do I chnage the permissions for my table locally? I can get in at the mysql command line but when i use something like mysqladmin I have no access to permissions.
Or is the standard method to go in at the command line change the permissions then upload the total sql text file to my remote server?
.
Changing permissions probably requires you to be root at mysql:
from command prompt:
mysql --user=root
and then something like..
grant all privileges on yourtable.* to user identified by 'password';
Should work for win and linux
thefisherman
