Forums

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!