View Full Version : [ubuntu] problem in running mysql

August 15th, 2010, 04:41 PM
when i run mysql - u root -p it runs but when i creeate database using CREATE DATABASE mydatabase it gives error as cannot find CREATE command. Also mysql prompt is not coming on command prompt.

August 15th, 2010, 07:57 PM
if you're not getting to a mysql prompt then you haven't actually logged in successfully. that would also explain the message about not finding the CREATE command, you're presumably entering that into your shell rather than mysql.

have you a mysql root password set, and are you entering it when prompted after you enter mysql -u root -p