Phpmyadmin Impossible de se connecter au serveur MySQL
Résolu
mobrobot
Messages postés
173
Date d'inscription
Statut
Membre
Dernière intervention
-
mobrobot Messages postés 173 Date d'inscription Statut Membre Dernière intervention -
mobrobot Messages postés 173 Date d'inscription Statut Membre Dernière intervention -
Bonjour,
Bonjour,
J'espère vous aller bien, s'ils vous plait ce problème ma beaucoup fatigue. j'utilise phpmyadmin pour me connecter a base de données. quand j'accède dans après 5second je suis déconnecter et rediriger a la page de connexion.
et l'erreur suivant s'affiche: mysqli::real_connect(): (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
voici le fichier de config.inc.php de phpmyadmin
<?php /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; // Address of your instance //$cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['user'] = 'username'; $cfg['Servers'][$i]['password'] = 'pword'; // Use SSL for connection $cfg['Servers'][$i]['ssl'] = true; // You need to have the region CA file and the authority CA file (2019 edition CA for example) in the PEM bundle for it to work $cfg['Servers'][$i]['ssl_ca'] = 'folder/DigiCertGlobalRootCA.crt.pem'; // Enable SSL verification $cfg['Servers'][$i]['ssl_verify'] = true; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['AllowNoPassword'] = true; $cfg['Lang'] = 'fr'; /* Bind to the localhost ipv4 address and tcp */ $cfg['Servers'][$i]['host'] = 'databasename.mysql.database.azure.com'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* User for advanced features */ //$cfg['Servers'][$i]['controluser'] = 'pma'; //$cfg['Servers'][$i]['controlpass'] = 'pword'; /* End of servers configuration $cfg['DefaultLang'] = 'en-utf-8'; $cfg['ServerDefault'] = 1; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; */ /* rajk - for blobstreaming $cfg['Servers'][$i]['bs_garbage_threshold'] = 50; $cfg['Servers'][$i]['bs_repository_threshold'] = '32M'; $cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600; $cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M'; */ /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark'; $cfg['Servers'][$i]['relation'] = 'pma__relation'; $cfg['Servers'][$i]['table_info'] = 'pma__table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma__column_info'; $cfg['Servers'][$i]['history'] = 'pma__history'; $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords'; $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; $cfg['Servers'][$i]['recent'] = 'pma__recent'; $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; $cfg['Servers'][$i]['users'] = 'pma__users'; $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings'; $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; $cfg['Servers'][$i]['favorite'] = 'pma__favorite'; $cfg['Servers'][$i]['LoginCookieValidity'] = 3600 * 3; /* * End of servers configuration */ ?>
Windows / Chrome 111.0.0.0
A voir également:
- Phpmyadmin Impossible de se connecter au serveur MySQL
- Se connecter à gmail sur téléphone - Guide
- Se connecter à ma boite hotmail - Guide
- Se connecter a chromecast - Guide
- Changer serveur dns - Guide
- Facebook se connecter à un autre compte - Guide