It might sound wrong, so you really need to get a bearing and collar and see how this works. Slip the bearing on the shaft and then put the lock on and barely tighten it by hand, the way you're doing it. Now hold the collar and turn the shaft and inner race like the bearing was starting to sieze. If you've tightened opposite the rotation, the collar will loosen. If you've tightened with the rotation, the collar will get tighter if the bearing tries to slip on the shaft.

I know, I know - it sounds wrong, but in this case, the wrong way is really the right way