CODEWITHSUNDEEP
phpmysqlherokuprivileges
Sauron
Sauron

Reputation: 6657

ClearDB: You need at least one of the super user privileges

I am attempting to import my ClearDB database in Heroku by running the command in the window:

mysql -u REDACTED -h us-cdbr-iron-east-02.cleardb.net -p REDACTED < C:/Users/KJA/Downloads/androidchatterdatabase.sql

After inputting the password, the error appears as:

ERROR 1227 (42000) at line 27: Access Denied; you need (at least one of) the SUPER privilege(s) for this operation

Then when seeing what the login is that would require the privileges it notes as:

Is there an alternative host address to use? How can I send my database schema to ClearDB in Heroku and run?

Upvotes: 1

Views: 1751

Answers (1)

dzuelke
dzuelke

Reputation: 2645

You need to select a database to work on by passing that as an argument to the command; you don't have privileges for any operation without a database (because that would let you control things at the "server level", not the database level).

Your command needs to be mysql -u YOURUSERNAME -h us-cdbr-iron-east-02.cleardb.net -p YOURPASSWORD heroku_XXXX < C:/Users/KJA/Downloads/androidchatterdatabase.sql (or whatever your database name is; I took "heroku_XXXX" from one of your other questions).

Upvotes: 1

Related Questions