Author Topic: creating database  (Read 3519 times)

Offline guidovanharten

  • Jr. Member
  • **
  • Posts: 13
creating database
« on: March 12, 2015, 12:58:50 PM »
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]
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]
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?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,879
    • SKaero - Custom Roundcube development
Re: creating database
« Reply #1 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.

Offline guidovanharten

  • Jr. Member
  • **
  • Posts: 13
Re: creating database
« Reply #2 on: March 12, 2015, 04:39:40 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.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,879
    • SKaero - Custom Roundcube development
Re: creating database
« Reply #3 on: March 12, 2015, 04:48:44 PM »
That should be in the privileges section.

Offline guidovanharten

  • Jr. Member
  • **
  • Posts: 13
Re: creating database
« Reply #4 on: March 12, 2015, 05:52:17 PM »
Thanks a lot. I think it works.