Bonjour,
Depuis 1 semaine que je tente de me connecter avec phpmyadmin. Je ne sais pourquoi, mais après avoir installé avec succès apache, mysql, php5, je suis prise avec ce problème:
Erreur
MySQL a répondu:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
J'ai suivi a la lettre un tas de tutoriaux, ai créé une table en mysql (invite dos). Je suis débutante en php, mais sais comment fonctionne phpmyadmin, sauf que la je voudrais héberger mon site sur un de mes pc et j'y arrive pas sans phpmyadmin.
Mon fichier config.inc.php:
en voici les principales composantes:
<?php
/* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */
/* $Id: config.default.php 9793 2006-12-15 17:36:07Z lem9 $ */
// vim: expandtab sw=4 ts=4 sts=4:
/**
* phpMyAdmin default configuration, you can copy values from here to your
* config.inc.php
*
* All directives are explained in Documentation.html
*/
/**
* Your phpMyAdmin URL.
*
* Complete the variable below with the full url ie
* http://www.your_web.net/path_to_yo [...] directory/
*
* It must contain characters that are valid for a URL, and the path is
* case sensitive on some Web servers, for example Unix-based servers.
*
* In most cases you can leave this variable empty, as the correct value
* will be detected automatically. However, we recommend that you do
* test to see that the auto-detection code works in your system. A good
* test is to browse a table, then edit a row and save it. There will be
* an error message if phpMyAdmin cannot auto-detect the correct value.
*/
$cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin';
/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfg['PmaNoRelation_DisableWarning'] = FALSE;
/**
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
* passphrase that will be used by blowfish. The maximum length seems to be 46
* characters.
*/
$cfg['blowfish_secret'] = '';
/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
// $cfg['Servers'][0]. You can disable a server config entry by setting host
// to ''. If you want more than one server, just copy following section
// (including $i incrementation) serveral times. There is no need to define
// full server array, just define values you need to change.
$i++;
$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]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$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'] = 'config'; // Authentication method (valid choices: config, http, HTTP or cookie)
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'monpass'; // MySQL password (only needed
// with 'config' auth_type)
Je ne sais que faire pour que cela fonctionne. Lors d'une autre tentative j'avais pas ce problème, mais en ajoutant mes login et pass cela ne fonctionnait jamais me disant utilisateur et mot de passe incorrect.
Lorsque je suis en invite dos, je peux voir root localhost mais je vois aussi root %....
Je suis vraiment a bout de ce probleme insoluble. Ai tout essayé avant de demander mais la.... c'est la totale
Merci si vous pouviez m'aider.
Linda
