How to change innodb_autoinc_lock_mode to be set to 0 from 1?

Question

How to change the global variable innodb_autoinc_lock_mode value 1 to 0 in MySQL?

Answer 1

Open your my.cnf and add the following line and make sure there is no space before or after the '=':

innodb_autoinc_lock_mode=0

or start mysql with the command line parameter:

--innodb_autoinc_lock_mode=0