I have managed to create a database in mysql, but i opened up CMD in windows to try add tables using the 'insert.sql' file provided.

They give you this code to do it...

cd \
cd Program Files\MySQL\MySQL Server 4.x\bin
mysql -uUser -pPassword CafeTownsend < insert.sql

I have edited the code accordingly to what i need to it say, but when i press enter in cmd i get 'Error 1045 <28000>: Access denied for user 'ODBC'@'localhost' <using password:yes'

Even though my password isnt yes?

My mate also had this problem when he tried to do it, does anyone know how to solve it?

if u dont specify a username it takes odbc as default,

try using root as the username and password

alternatively, you can redo the installation and this uncheck the option which allows you to set a root password.