Then tried to create a database called kilo using the command
create database kilo;
and was greeted with the error below. ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'kilo'
The problem was in the space between -u and root. So the correct command to use is mysql -uroot -ppassword