Search code examples
mysqlcloudbees

Changing `auto_increment_increment` in a DB at a web hosting provider

I deployed a web application to CloudBees, and created a MySQL DB with the one-click GUI. It looks like auto_increment_increment option is set to 10 (id in a table increases by 10 with each new row). I tried to change the auto_increment_increment:

SET GLOBAL auto_increment_increment=1;

But I got an error: Error Code: 1227. Access denied; you need (at least one of) the SUPER privilege(s) for this operation.

How can I change the auto_increment_increment?

Solution

  • Extrange configuration in your provider....

    According to the manual:

    The SUPER privilege is required to set global variables.

    So you need to access with a user with this privilege, you should ask to your provider about it.

    Of course you can change this variable for your session:

    SET SESSION auto_increment_increment=1;

    You don't need any especial privilege to do this