Se connecter avec
S'enregistrer | Connectez-vous

Erreur identifiant Mysql

Dernière réponse : dans Programmation

Salut !

Je viens de tenter de modifier mon pass et mon login pour l'acces à Mysql...quelle erreur !

Impossible de m'y reconnecter via l'interface de PhpMyAdmin.

Citation :
phpMyAdmin a tenté de se connecter au serveur MySQL, et le serveur a rejeté la connexion. Veuillez vérifier les valeurs de "host", "username" et "password" dans config.inc.php et vous assurer qu'elles correspondent aux informations fournies par l'administrateur du serveur MySQL.

Erreur

MySQL a répondu:


#1045 - Access denied for user: 'mon_nom@localhost' (Using password: YES)



J'ai aussi essayé de modifier config.inc.php. Voici le début de mon code :
  1. if (!isset($old_error_reporting)) {
  2. error_reporting(E_ALL);
  3. @ini_set('display_errors', '1');
  4. }
  5.  
  6.  
  7. /**
  8. * Your phpMyAdmin url
  9. *
  10. * Complete the variable below with the full url ie
  11. * <a href="http://www.your_web.net/path_to_your_phpMyAdmin_directory/" target="_blank">http://www.your_web.net/path_to_your_phpMyAdmin_directo...</a>
  12. *
  13. * It must contain characters that are valid for a URL, and the path is
  14. * case sensitive on some Web servers, for example Unix-based servers.
  15. *
  16. * In most cases you can leave this variable empty, as the correct value
  17. * will be detected automatically. However, we recommend that you do
  18. * test to see that the auto-detection code works in your system. A good
  19. * test is to browse a table, then edit a row and save it. There will be
  20. * an error message if phpMyAdmin cannot auto-detect the correct value.
  21. *
  22. * If the auto-detection code does work properly, you can set to TRUE the
  23. * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
  24. */
  25. $cfg['PmaAbsoluteUri'] = '';
  26.  
  27.  
  28. /**
  29. * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
  30. * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
  31. * works perfectly.
  32. */
  33. $cfg['PmaAbsoluteUri_DisableWarning'] = TRUE;
  34.  
  35. /**
  36. * Disable the default warning that is displayed on the DB Details Structure page if
  37. * any of the required Tables for the relationfeatures could not be found
  38. */
  39. $cfg['PmaNoRelation_DisableWarning'] = FALSE;
  40.  
  41. /**
  42. * The 'cookie' auth_type uses blowfish algorithm to encrypt the password.
  43. * If at least one server configuration uses 'cookie' auth_type,
  44. * enter here a passphrase that will be used by blowfish.
  45. */
  46. $cfg['blowfish_secret'] = '';
  47.  
  48. /**
  49. * Server(s) configuration
  50. */
  51. $i = 0;
  52. // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
  53. // You can disable a server config entry by setting host to ''.
  54. $i++;
  55. $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
  56. $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
  57. $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
  58. $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
  59. $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
  60. // (requires PHP >= 4.3.0)
  61. $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
  62. // (this user must have read-only
  63. $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
  64. // and "mysql/db" tables)
  65. $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
  66. $cfg['Servers'][$i]['user'] = 'mon_login'; // MySQL user
  67. $cfg['Servers'][$i]['password'] = 'mon_pass'; // MySQL password (only needed
  68. // with 'config' auth_type)
  69. $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
  70. // this db is displayed
  71. // at left frame
  72. // It may also be an array
  73. // of db-names
  74. $cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
  75.  
  76. $cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features
  77. // (see scripts/create_tables.sql)
  78. // - leave blank for no support
  79. // DEFAULT: 'phpmyadmin'
  80. $cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table
  81. // - leave blank for no bookmark support
  82. // DEFAULT: 'PMA_bookmark'
  83. $cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc)
  84. // - leave blank for no relation-links support
  85. // DEFAULT: 'PMA_relation'
  86. $cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields
  87. // - leave blank for no display fields support
  88. // DEFAULT: 'PMA_table_info'
  89. $cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema
  90. // - leave blank for no PDF schema support
  91. // DEFAULT: 'PMA_table_coords'
  92. $cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf
  93. // - leave blank if you don't want to use this
  94. // DEFAULT: 'PMA_pdf_pages'
  95. $cfg['Servers'][$i]['column_info'] = ''; // table to store column information
  96. // - leave blank for no column comments/mime types
  97. // DEFAULT: 'PMA_column_info'
  98. $cfg['Servers'][$i]['history'] = ''; // table to store SQL history
  99. // - leave blank for no SQL query history
  100. // DEFAULT: 'PMA_history'
  101. $cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your PMA_* tables
  102. // are up to date. This prevents compatibility
  103. // checks and thereby increases performance.
  104. $cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use
  105. = '';
  106. $cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults
  107. = array();


Rien à faire, toujours la même erreur !!!

D'où vient le problème svp ?

Merci d'avance

Micha

Autres pages sur : erreur identifiant mysql

Lassé par la pub ? Créez un compte
Lassé par la pub ? Créez un compte