US President Barack Obama has said failing to prepare for the aftermath of the ousting of Libyan leader Col Muammar Gaddafi was the worst mistake of his presidency.