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 (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:
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?
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?
I'm not familiar with DirectAdmin but most likely you need to do that from the portal not PHPMyAdmin.
Quote from: SKaero on March 12, 2015, 04:06:41 PM
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.
That should be in the privileges section.
Thanks a lot. I think it works.