I'll probably change my plans and use a 5/16" OD steel tube instead of
a rod, then grind the motor shaft gear down to the inner diameter of
the steel tube, and then roughen both surfaces and glue them together.
At least that should work better than the last way I tried doing it.

Thanks to the replies.