Will it affect my credit rating?

Yes, your ability to get credit will be affected for 6 years