Ouvrir l accès au port de 3306 et à Mysql?

1- Créer un super-utilisateur sur MYSQL
Code

grant ALL privileges ON *.* TO log@localhost IDENTIFIED by 'pass' WITH grant option;
grant ALL privileges ON *.* TO log@ "%" IDENTIFIED by 'pass' WITH grant option;

2- Autoriser mysql en accés distant (mode console)
2.1- Sur la version 7.x de SME Server
Code

db configuration setprop mysqld LocalNetworkingOnly no
db configuration setprop mysqld TCPPort 3306
db configuration setprop mysqld access public
expand-template /etc/rc.d/init.d/masq
expand-template /etc/my.cnf
service mysqld restart
service masq restart

2.1- Sur la version 6.x de SME Server
Code

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

Un grand merci à zeric, pour cette soluce.
Source : Ixus.net

Category: 
E-Smith