Web Hosting Forums

Results 1 to 2 of 2

This is a discussion on Grant access to database in DirectAdmin in the Hosting Talk & Chit-chat forum
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 ...

  1. #1
    Loyal Client
    Join Date
    Oct 2006
    Posts
    2

    Question Grant access to database in DirectAdmin

    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 [email protected] 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!

  2. #2
    Banned JPC-Veena's Avatar
    Join Date
    Sep 2002
    Posts
    565
    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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •