Mass modify projects's visibility_level in gitlab using mysql console

I just want to make all of my company's repositories in gitlab become accessible to the internal users (Visibility Level = Internal). But I don't wanna do it one by one. So I go to the database:

mysql> use our_gitlab_db;
mysql> update projects SET visibility_level = 10 WHERE visibility_level != 10;

Pretty neat huh?!

Comments