creating database

[guidovanharten]

I am not familar with php and phpmyadmin, so I hope anyone can help me.
The manual I am using is on http://trac.roundcube.net/wiki/Howto_Install
I have to create a database using DirectAdmin. The database name has to start with the username of my hostingaccount and "_", i.e. "guido_", so the name should be: guido_rc.
Then I go to phpmyadmin. The manual tells me in the chapter Database Configuration to use the SQL-commands:

Code Select Expand

CREATE DATABASE roundcubemail;
GRANT ALL PRIVILEGES ON roundcubemail.* TO username@localhost IDENTIFIED BY 'password';
The first line I have done using DirectAdmin, so in phpmyadmin at the left side I select these database. Then I go to the SQL-editor and copy the 2nd line.
Now my problem:
What do I have to change in this line?

Code Select Expand

GRANT ALL PRIVILEGES ON guido_rc.* TO guido@localhost IDENTIFIED BY 'secret';

But that gives the error message:
#1044 - Access denied for user 'guido'@'localhost' to database 'guido_rc'

Who can help me?

[SKaero]

I'm not familiar with DirectAdmin but most likely you need to do that from the portal not PHPMyAdmin.

[guidovanharten]

I'm not familiar with DirectAdmin but most likely you need to do that from the portal not PHPMyAdmin.

Which portal do you mean? In (the Mysql-section of) DirectAdmin I only can create and delete databases, modify password and privileges.

[SKaero]

That should be in the privileges section.

[guidovanharten]

Thanks a lot. I think it works.