i need help with mysql

[adamp]

hellow
i need to allow remote access to my mysql
how can i do it?

thank you

 

[rohit]

make sure that port 3306 is open on firewall

then in DA under MySQL there is section to manage the remote ip address.

 

[adamp]

make sure that port 3306 is open on firewall

then in DA under MySQL there is section to manage the remote ip address.

i think that you not understand the problem

i want to contact to MYSQL from other computer

 

[rohit]

yes, I did understand what u were asking and my reply is correct as well

mysql runs on port 3306, so in order to allow the external traffic to connect to mysql u need to make sure that the port 3306 is open for connection

also u also need to create an entry using DA to allow external access to mysql DD by creating a un and pw

 

[adamp]

but i need to do something on the mysqld config
to allow remote access.

 

[Driesp]

You can add a new user via phpmyadmin (logging in as root)
and use a % in the host box
so every host kan remotly login to your mysql server

 

[adamp]

You can add a new user via phpmyadmin (logging in as root)
and use a % in the host box
so every host kan remotly login to your mysql server

how i can do this?

you can write what to do

 

[Driesp]

You can use DirectAdmin too to change users external host.

Login in DirectAdmin
Goto "MySQL Management"
Select the user that must have external login permitions.
And type in the host box a % character,
press add to finish.

Now you can login remotly with that user.

Dries

 

[adamp]

You can use DirectAdmin too to change users external host.

Login in DirectAdmin
Goto "MySQL Management"
Select the user that must have external login permitions.
And type in the host box a % character,
press add to finish.

Now you can login remotly with that user.

Dries

to do this from DA