Context Navigation

Changes between Version 73 and Version 74 of MySqlDb

Timestamp:: Mar 22, 2016, 9:51:22 PM (8 years ago)
Author:: Ryan J Ollos
Comment:: Document autoincrement issue that was recently discovered in a particular installation.

v73	v74
161	161	1. Created user is not yet used by MySQL. Login to the MySQL server as root with `mysql -p` and type: `FLUSH PRIVILEGES;`
162	162	1. The user is added but the host does not match in the MySQL user table (occurred on a FreeBSD setup). Correct this with: `mysql -p; use mysql; UPDATE user SET Host="localhost" WHERE User="tracuser"; FLUSH PRIVILEGES;`
	163
	164	==== Ticket numbers are not incrementing by one
	165
	166	The database schema specifies autoincrement for several columns, including the column for ticket IDs. In MySQL, the autoincrement value is configurable and defaults to `1`. If the sequence of ticket IDs is not incrementing by 1, the [http://dev.mysql.com/doc/refman/5.7/en/replication-options-master.html#sysvar_auto_increment_increment auto_increment_increment] value in `my.cnf` probably needs to be changed to `1`.