Einen wunderschönen Guten Morgen alle zusammen
Habe folgendes Problem
wenn ich PhpMyAdmin öffnen will...http://localhost/phpMyAdmin-2.2.0-rc4/main.php, bekomme ich folgende Fehlermeldung.....
Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in ./lib.inc.php on line 351
Fehler
Falls ich etwas mit dem Passwort falsch gemacht habe,wo kann
man die Einstellungen ändern???
Vielen Dank im vorraus
jenne
Hi,dort steht aber kein Passwort drin...
$cfgServers[1]['password'] = ''; // MySQL password (only needed with basic auth)
jenne
Was hast du den für ein Passwort bei der MySQL installation eingegeben? Das musst du dort eintragen.
Hi Gilbert
Bei my.ini Setup stehen user=jens und password=jenspw das habe ich in der config.inc.php eingegeben
$cfgServers[1]['stduser'] = ''jens; // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = ''jenspw; // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'jens'; // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = ''jenspw; // MySQL password (only needed with basic auth)
dann kommen aber nur Fehler......
Parse error: parse error in ./config.inc.php on line 35
Warning: Variable passed to reset() is not an array or object in ./lib.inc.php on line 163
Warning: Variable passed to each() is not an array or object in ./lib.inc.php on line 164
Warning: MySQL Connection Failed: Access denied for user: 'ODBC@localhost' (Using password: NO) in ./defines.inc.php on line 42
Warning: MySQL: A link to the server could not be established in ./defines.inc.php on line 42.......
möglich das ich bei der instalation ein anderes eingegeben habe
aber bis gestern ist alles 3Wochen lang gelaufen
:dontknow:
jenne
Der Bereich muss so aussehen:
$cfgPmaAbsoluteUri = 'http://localhost/php/';
/**
* Server(s) configuration
*/
// The $cfgServers array starts with $cfgServers[1]. Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port
$cfgServers[1]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfgServers[1]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfgServers[1]['controluser'] = ''; # // MySQL control user settings
// (this user must have read-only
$cfgServers[1]['controlpass'] = ''; # // access to the "mysql/user"
// and "mysql/db" tables)
$cfgServers[1]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfgServers[1]['user'] = 'jenny'; // MySQL user
$cfgServers[1]['password'] = 'jennypass'; // MySQL password (only needed
// with 'config' auth_type)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only
so sieht es jetzt aus aber alle Fehler sind noch da
$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = FALSE; // Use advanced authentication?
$cfgServers[1]['stduser'] = ''; // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = ''; // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'jens'; // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = ''jenspw; // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfgServers[1]['bookmarkdb'] = ''; // Bookmark db - leave blank for no bookmark support
$cfgServers[1]['bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support
Sieht gut aus. Und was sagt PHPMyAdmin?
Mach es mal so.
Original geschrieben von jenne
$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = FALSE; // Use advanced authentication?
$cfgServers[1]['stduser'] = 'jens'; // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = 'jenspw'; // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'jens'; // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = ''jenspw; // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfgServers[1]['bookmarkdb'] = ''; // Bookmark db - leave blank for no bookmark support
$cfgServers[1]['bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support
Ich muß zu Fielmann Gilbert
der fehler war das Hochkomma!!! Jetzt funzt es.
Vielen Dank
jenne
sorry dieses Hochkomma bei jenspw
$cfgServers[1]['password'] = ''jenspw; // MySQL password (only needed with basic auth)
jenne
Original geschrieben von jenne
$cfgServers[1]['password'] = 'jenspw'; // MySQL password (only needed with basic auth)
So soll es heissen.
Ja Gilbert
hab es auch gesehen und nur den fehler geschickt,aber daran siehst Du mit welchen sachen Anfänger einen Nerven können!
Danke jenne
Ja
schon seid ,,Ich muß zu Fielmann Gilbert"
jenne
