mySQL problems (mySQL newb)

[mka]

I am trying to get phpnuke up. I am using a guide off the internet that says I need to create a database named "nuke".

When I try to create a database I get this:

user@mycomputer:~/html$ mysqladmin create nuke
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'nuke''

As I am a complete newb to php and mySQL, I was wondering if someone might be able to point me in the right direction.

I also downloaded phpmyadmin but I have NOOOOOOO idea how to use it! Any help there would also help!

Thanks!

[theN]

Originally posted by mka
user@mycomputer:~/html$ mysqladmin create nuke
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'nuke''MySQL user identified by the name user does not have CREATE database privilege on a computer named mycomputer or user does not have a WRITE permission to folder ~/html.

You could try the following-
* Ascertain user's permissions to the folder ~/html
* Login as the default MySQL root and CREATE the database
* Use MySQL root to GRANT privileges such as CREATE, UPDATE, DELETE and DROP etc. to user@mycomputer

The last option is the safest!! Irrespective of your choice, please read the MySQL manual about MySQL's "user privileges" management.

hth
theN