How to overwrite default mysql-user 'Access Hosts'?

[differentlocal]

By defualt, users 'Access Hosts' contains only localhost.

But I need to add other IP to 'access hosts' of all users on the server for using remote phpMyAdmin (one for all servers). And create\modify template for new users.

How\where?

 

[differentlocal]

Up. (ten symbols)

 

[nobaloney]

Up. (ten symbols)

What is the above supposed to mean?

Jeff

 

[differentlocal]

What is the above supposed to mean?

Jeff

This means that solution not found, but topic goes down to 2 page.

 

[nobaloney]

So you're posting again just to bring your post to the top of the list? After less than 24 hours? That seems a bit unfriendly to me. Give it a bit longer please. And only do it once or twice. If by then no one has answered it's probably because no one knows the answer.

Jeff

 

[differentlocal]

So you're posting again just to bring your post to the top of the list? After less than 24 hours? That seems a bit unfriendly to me. Give it a bit longer please. And only do it once or twice. If by then no one has answered it's probably because no one knows the answer.

Jeff

Ok, sorry.

 

[SeLLeRoNe]

for give access to everyone into a specific database go into mysql setup into directadmin panel, go into the db you wanna edit and add % into access list

 

[differentlocal]

for give access to everyone into a specific database go into mysql setup into directadmin panel, go into the db you wanna edit and add % into access list

Thx, but I need to do that globally, for all users on server. Any way to do that?

 

[SeLLeRoNe]

maybe you need a post_create.sh script or a custom conf file that add automatically the % host for the created user (that wouldnt work for already existing) but for be more sure i suggest you to contact directadmin staff