Redmine

This is something that has been discussed (and rejected) many times before. See #5765 and all its related issues.

Yeah, I read thru that before posting. Not asking for the feature to be added, just wanting to know if there is a way to have the DB start from zero. Think this may work...

On console (since we're using linux):
mysql -u<user> -p<password> redmine
Replace <user> and <password> with the correct information to connect to
your database.
Now, run this command on the mysql console:

mysql> ALTER TABLE issues SET auto_increment = <number>;
mysql> quit;

Replace <number> with the number you want to use as the 'starting point' for
your issues.

Rocky Stephens wrote:

[...] Think this may work... [...]

I personally wouldn't recommend (re)setting the auto_increment value manually as this may pose problems lateron. However, if you know what you're doing and you are willing to take the 'risk', YMMV.

Please kindly help, I face the same issue that is I also want to start Issue No.1

That above script can't work because of it show error message at auto_increment

Please kindly give another suggection.

Redmine is not designed to reset its issue numbers or to have numbering per project. There were plugins in the past that added this functionality though.

I don't understand the reason for this need either...
If only 1 project is required at a time, then set up Redmine freshly and then make a backup of the database before the first issue is created - this way you can import this backup again after the project is completed and start over - with issue id 1 (forget not to delete all possible file attachments beforehand!)

There's a plugin which tries to achieve this, but it's quite outdated and not compatible with current versions of Redmine.
If one's willing to make it compatible again, here's the link: https://www.redmine.org/plugins/issue_id