[Resolved] mysql install help

[helmz]

I'm new to php and mysql, and when I try to create database using this command
create database name;

the following error occurs

ERROR 1044: Acces denied for user '@' to database 'name'

Any solution to this?

[rachel2004]

1. are you logged into the MySQL server? If you are, you should see a prompt similar to:

mysql>

From here, you cannot run queries and so forth. You cannot execute SQL commands if you are not connected to the MySQL server.

2. If you are logged into the MySQL server and are getting that error message, you don't have the correct privileges to create a database.

[helmz]

Thanks for the reply, and yes I can see
mysql>
Okay at this point I can create tables within "test" Database, but I cannot create new databases other than "test", it gives the same error, ERROR 1044

And about priviliges can you go more into it?i

[czambran]

Try connecting to mysql as root.

mysql -u root

[helmz]

Tried and it says this:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) 😕

[helmz]

I'm done thanks guys 🙂 , I tried
mysql -u root -p
and it prompted me for the password, I gave mine and its working now
thanks again