Dmz para acceso externo e interno: Page 2

Dmz para acceso externo e interno

ntozier

based on the bind address I would say that your mysql server is only listening on localhost.

mremersaro

entonces ahi el bind-adress reemplazo esa IP por la IP del server DMZ? o lo agrego?

ntozier

I believe that the generally accepted practice is to either: comment out that line, or configure the real IP of the server. You would want to research best practices for this however.

mremersaro

ntozier esto lo ejecuto desde el server LAN (donde esta mi mysql)? o desde el server DMZ?

Modifique el my.cnf y puse en bind-address = 0.0.0.0.

Pero desde el server DMZ ejecute mysql -h 192.168.21.35 -u root -p y me dio este error:

ERROR 1130 (HY000): Host '10.70.70.42' is not allowed to connect to this MySQL server

ntozier

You should try to connect from the DMZ server to the DB server.

Setting your servers IP to 0.0.0.0 is neither of the options I suggested.

You should research the error:

mremersaro ERROR 1130 (HY000): Host '10.70.70.42' is not allowed to connect to this MySQL server

mremersaro

Listo Ntozier, he logrado configurarlo.
Le consedi permisos a la ip DMZ en el server LAN:

CREATE USER 'root'@'ip_address' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON . TO 'root'@'ip_address';

Muchas por todo

ntozier

de nada mi amigo

« Previous Page