php - Variable 'innodb_lock_wait_timeout' is a read only variable -
i want change innodb_lock_wait_timeout mysql variable. tried using command set innodb_lock_wait_timeout=900; but when ran got following error: error 1238 (hy000): variable 'innodb_lock_wait_timeout' read variable default @@innodb_lock_wait_timeout 50 want change 900. how can this? innodb_lock_wait_timeout can set @ runtime set global or set session statement. changing global setting requires super privilege , affects operation of clients subsequently connect. client can change session setting innodb_lock_wait_timeout, affects client. you may change config file my.cnf , add innodb_lock_wait_timeout=900.