For SQLite there is a table named SQLITE_SEQUENCE with all the auto incremental values of the tables, so you need to update the value.
UPDATE SQLITE_SEQUENCE SET seq = [starting_number] WHERE name = '[table_name]';
Just change [starting_number] for the desired initial auto increment and [table_name] for the name of the table to update
There are several programs that make this happen, but after I tried some of them I found very useful one of them KAZAM
It’s very simple to install
sudo apt-get install kazam
And just run it
You can view this post for other options for it
There is no need to say that this is a security risk and a performance killer, but sometimes in debug I need to checkout every single query made to the server, so in order to do this, at least on MySQL 5.7.17 it can be enabled on runtime.
I usually only put in this blog working solutions proved by me, but in this case I did so many things that I can’t recall how I make that VPN working, but from my browser history I can reference to some of the posts that helped me do it. And the last thing that I did to make it work. I promise to update this post when I need to make this process again with the solution but until that I can’t erase it to make the process again (I don’t have the time for it)
I was just copying the public key and then accesing the server to make the authorized_keys file and so on, but this command does that automatically.
cat ~/.ssh/id_rsa.pub | ssh USER@HOST "mkdir -p ~/.ssh && cat >> ~/.ssh/authorized_keys"
I was just having trouble because you can’t use the same RSA key in order to connect to multiple accounts on bitbucket, this can be solved creating a new one, but you need to know how to handle them, and there is two ways to do it.
If you just need to connect with ssh to a host well you can just put it as a parameter, but this doesn’t work as a complete solution.
ssh -i PATH_TO_SSH_KEY email@example.com
I forgot a lot about the configurations needed to associate my own email account on the different applications, so here they are