I want to change something on my console, But I got this
ALTER TABLE treehole.user ADD unique (username);
ERROR 1142 (42000): ALTER command denied to user 'treehole'@'10.0.0.63' for table 'user'
So what should I do now?
I want to change something on my console, But I got this
ALTER TABLE treehole.user ADD unique (username);
ERROR 1142 (42000): ALTER command denied to user 'treehole'@'10.0.0.63' for table 'user'
So what should I do now?
You should rather use username$database_name.table_name
to describe the thing to be altered, since full mysql database names on PythonAnywhere have the format username$database_name
(see the help page), but if you started the mysql console in that particular database, table_name
should be enough.
Well that works. Thanks. mysql> ALTER TABLE treehole$treehole.user ADD unique (username);
Glad to hear that!