salut a tout les LINUXIEN !
voila j’un serveur APACHE + PHP + MYSQL + PGSQL + PHPMYADMIN + PHPPGADMIN sous DEBIAN
ensuite j’ai un serveur APACHE + PHP + PHPMYADMIN sous windows !
les 2 PC sont en reseau le reseau est OK !!
si je meconnecte depuis mon poste windows sur
apache(debian) -> PHPMYADMIN(debian) -> MySQL(debian) -> OK
config.inc.php de phpmyadmin sous DEBIAN
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
par conte si j’utilise le
apache(windows) -> PHPmyAdmin(windows) -> MySQL(debian) -> ERREUR
#2003 - Can’t connect to MySQL server on ‘debian’ (10061)
j’arrive pas a me connecter
pourtant le mots de passe sont OK
config.inc.php pour phpmyadmin sous windows
$cfg['Servers'][$i]['host'] = 'debian';// ou 10.0.0.1 -> IP de mon poste debian // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
donc a mon avis ya surement comme pour pgSQL un fichier de conf a modifier pour autoriser les poste reseau a se connecter !!
(pg_hba.conf pour pgsql)
si jamais qq1 connait la reponse qu’il me fasse signe !!