Sir Alex Ferguson has said he was "terrified" about returning to Old Trafford following a brain haemorrhage.