Bonjour a tous,
Savez vous comment accéder a phpmyadmin depuis l'exterieur, pas de probleme depuis l'interieur.
Merci de vos réponses
Nicolas Candelier
Modérateur: modos Ixus
Access MySQL from the local network
MySQL on SME Server is run on a socket instead of on a port. MySQL on SME Server is by default configured to allow only localhost connections to improve security, this means that it is only accessible from the server itself and not from the local network nor from the internet. If you wish to enable local network access, execute the following commands on a SME Server shell as root:
config setprop mysqld LocalNetworkingOnly no
expand-template /etc/my.cnf
sv t /service/mysqld
Access MySQL from a remote network
If you wish to enable access to MySQL databases from remote networks, then in addition to the LocalNetworkingOnly db setting mentioned above, you will need to execute the following commands:
config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event reboot
Keep in mind this enables access to your MySQL database for ANYONE, so make sure you have strong passwords on ALL your MySQL databases. Alternatively it would be a more secure approach to require external (remote) users to establish a VPN connection and effectively become part of the local network. In that case do not change the mysql access to public status using the above command.
Retour vers E-Smith / SME Server
Utilisateur(s) parcourant actuellement ce forum : Aucun utilisateur inscrit et 1 invité