I need help creating a database on OS X Leopard

[peterv12]

I want to create a database named books. I get into mysql, and type the create databaase command but I get an access denied error. I'm new to OS X so I'm not sure how to debug this error. Can anyone please help me out?

peterv@Macintosh-2.local<502>$: mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51b Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

[b][COLOR=blue]mysql> create database books;[/color][/b]
[b][COLOR=red]ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'books'[/color][/b]

 

[cyoung]

You need to log into the MySQL client with a username that has the rights to create a database.

$mysql -u <username> -p

Hope this helps