I'm working on a joint project with eepman, and it would be very convenient if I was able to create a phpmyadmin account to allow him to modify the database directly.

Ideally, I'd like to have him only be able to access one specific database, but I'll give him access to all the databases if I have to in order to accomplish this. I do not, however, want to give him access to all of directadmin.

Is this possible, and if so, how do I do it?

mathiaus

Very simple, this will allow him access to the databases you add him to;
DA -> MySQL Management
Choose your database to add him to. Click it's name.
Click 'Create New Database User'
Enter a username and password
"User added to database"
Click HERE to go back
If required click 'Modify Privileges' for the user.

ocalhoun

but then can he use phpmyadmin?
I knew how to do that, but I didn't think it would grant phpmyadmin access.

ninjakannon

Yes, I'm pretty sure that if he goes to his DirectAdmin then clicks on phpMyAdmin and types in the username and password that you created for him it will open your database and he will be able to use it.
But obviously I haven't been able to test this.

mathiaus

ocalhoun wrote:

but then can he use phpmyadmin?
I knew how to do that, but I didn't think it would grant phpmyadmin access.

Course it does, I wouldn't have bothered to spend the time testing and then posting about if it didn't.
He can login to http://frih.net/phpMyAdmin/ with the user and pass you just created