MySQL Help? New User?

I am completely new to PHP so I don%26#039;t really know what I%26#039;m doing...

I have to create a database with a user that has all access to the database.

I did this by logging into my web hosting account and going through a wizard to create a database, then adding a user who%26#039;s role was set to %26quot;dba%26quot;.

I checked their %26#039;privileges%26#039; through the web hosting and all the boxes are ticked, such as grant, select, insert, delete, update, create, view, and all the others.

But the user still does not seem to have all privileges? :(

So I tried going into phpMyAdmin and clicking the icon that leads to the %26#039;Query window%26#039; (I don%26#039;t even know if that%26#039;s what I%26#039;m meant to do, just guessing) and I entered in:

GRANT ALL ON database.* TO user@localhost IDENTIFIED BY %26quot;password%26quot;;

with the correct details and in return get an error message that says, %26quot;Access denied for user %26#039;user%26#039;@%%26#039; to database %26#039;database%26#039;

How do I get the user to have all privileges? I%26#039;ve never used PHP before, sorry for my ignorance.

MySQL Help? New User?

go back into MySQL databases and choose that user you just set up and it should show you all those boxes and an ALL box, just check the all box and enter or ok

different versions are a little different so I don%26#039;t know what version you are using

make sure you have the username correct and password when you are accessing it.

sometimes you have to put your main ID as the first part and then a _ and the username as your ID for logging in

phpmyadmin is just for the database itself, not for setting up a user