I am getting an error when I try to add a column to my mysql table. It says “you do not have the PROCESS privilege at /user/local/bin/pt-online-schema-change line 4320, line 1.”
My command is below:
sudo pt-online-schema-change --alter “ADD COLUMN X INT” D=mydatabase,t=‘machine velocity’,h=server@somewhere.com,u=my_username --execute --ask-pass
At first I thought maybe it was because my table title has a space in it, but I tried the same thing with another table with no spaces and had the same error.
When I run a dry run, there are no apparent errors. I only get this error when I change dry-run to execute.