Grant access to database in DirectAdmin

[Auriga]

I have setup a mySQL database using the DirectAdmin control panel. Now I'd like to give users remote access to this database. When i try to setup the GRANT command using command line, I get an error:

mysql> GRANT ALL ON my_database.* TO user@adomain.com IDENTIFIED BY 'a_password';

ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'my_database'

However, I did login using the same password and login as I use to startup DirectAdmin:

mysql -u admin -p my_database

And I can view the tables using

show tables;

I cannot however login as root in my database (using the password of my root account).

What am i doing wrong?

Thanks!

[JPC-Veena]

Auriga,

Directadmin has an admin user named da_admin for mysql instead of root or admin. da_admin details can be found in the file
/usr/local/directadmin/conf/mysql.conf
You can also open a support ticket if you need help