Remote connection problem

[Atlantis95]

Good day,

Ik have two MySQL issues.

1. Configuration issue concerning the hostname.
I try to make JDBC connection to the MySQL server on my DirectAdmin server.

To succeed the connection I must add the hostname of my internet connection to the MySQL configuration (DirectAdmin part of the configuration).

My question:
Is there a default value for accepting each incomming connection independend from the host for a particular MySQL user?

2. Configuration issue concerning the permissions.
When I normally user phpMyAdmin, I am able to set permissions specified on 'table level' for particular users.

I should like to give a user connection permission for reading, updating, inserting on a particular version. With the normal MySQL version it is possible. At the standard version of MySQL I can add more users accessing the same database.

How to do this using DirectAdmin? To let this work, I need to add a second user to the same database with limited access.

Who can supply me with more details?

 

[jmstacey]

You should be able to do it through DirectAdmin's MySQL Management page. If not, you can simply login as root or da_admin to phpmyadmin and make the changes you want.

By default only localhost connections are allowed to MySQL. This setting is on a per database level and can be done through directadmin.

 

[Atlantis95]

The ' DirectAdmin's MySQL Management page' is limited by adding specific domain names. So far I know should I be able to set a '*' as default for passing each extern connection. That is not possible (host unknown).

What is the procedure for installing phpMyAdmin that way, that all databases from all users can eb reached and I am able to add/change permissions. phpMyAdmin is able to manage the permissions and makes live very easy.