ich habe probleme mit meinem lokalem mysql server den ich auf meinem pc laufen habe.
wenn ich nun z.b. mit phpmyadmin versuche mich anzumelden, heisst es immer:
Code: Alles auswählen
#1045 - Access denied for user: 'simon@localhost' (Using password: YES)Code: Alles auswählen
#This File was made using the WinMySQLAdmin 1.4 Tool
#13.12.2003 12:59:12
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=E:/Programme/Mysql
#bind-address=127.0.0.1
datadir=E:/Programme/Mysql/data
#language=E:/Programme/Mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=E:/Programme/Mysql/bin/mysqld-nt.exe
user=simon
password=mein_password #habe ich mit fake ersetzt!!!!
Code: Alles auswählen
$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 ''.
$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]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = 'simon'; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = 'password'; // access to the "mysql/user" ist nich das richtige password, aber beide stimmen bei mir überein!!!
// and "mysql/db" tables)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'simon'; // MySQL user
$cfg['Servers'][$i]['password'] = 'password'; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed
// at left frame
// It may also be an array
// of db-names
