Hallo Wiedmann, danke für deine Antwort.
Sorry habe mich vertan mit MySQLAdmin und phpMyAdmin.
Hab alles noch mal neu installiert um einen sauberen stand zu haben.
In phpMyAdmin User und DB eingerichtet, überprüft ob Server läuft, sowie User und neue DB eingerichtet sind, alles ok.
Noch mal in WinMySQLadmin überprüft, im Bereich MyODBC Fenster "
Not Found Driver 3.51 Not Found" ansonsten keine negativen Meldungen.
In php.ini
register_globals =
On gesetzt. "nur im Admin Verzeichnis" ok oder?
[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On
; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1
; Maximum number of links (persistent + non-persistent). -1 means no limit.
mysql.max_links = -1
; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
mysql.default_port =
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =
; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =
; Maximum time (in seconds) for connect timeout. -1 means no limit
mysql.connect_timeout = 60
; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off
nichts geändert
In config.inc.php
$cfg['blowfish_secret'] = '
password in klar text';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['ssl'] = false;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = '
cookie';
$cfg['Servers'][$i]['user'] = '
User Name den ich neu eingetragen habe in phpMyAdmin';
$cfg['Servers'][$i]['password'] = '
password in klar text';
$cfg['Servers'][$i]['SignonSession'] = '';
$cfg['Servers'][$i]['SignonURL'] = '';
$cfg['Servers'][$i]['LogoutURL'] = '';
$cfg['Servers'][$i]['nopassword'] = FALSE;
$cfg['Servers'][$i]['only_db'] = '';
$cfg['SQLValidator']['use'] = False;
$cfg['SQLValidator']['username'] = '';
$cfg['SQLValidator']['password'] = '';
keine Änderungen vorgenommen
In configure.php nur in \admin\includes geändert, OK ?
// define our database connection
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', '
User Name');
define('DB_SERVER_PASSWORD', 'v
erschlüsseltes password zu mindestens nicht in klar text');
define('DB_DATABASE', '
DB Name');
define('DB_TABLE_PREFIX', '
Bestandteil vom DB Name');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'
?>
Fehler Meldung bleibt
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Gleicher User Name von DB'@'localhost' (using password: YES) in F:\xampp\htdocs\osc\includes\functions\database.php on line 19
Unable to connect to database server!
<?php
/*
$Id: database.php,v 1.21 2003/06/09 21:21:59 hpdl Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') {
global $$link;
if (USE_PCONNECT == 'true') {
$$link = mysql_pconnect($server, $username, $password);
} else {
$$link = mysql_connect($server, $username, $password);
}
Ich glaube das war alles was ich bis jetzt gemacht habe.
Habe keine anderen Ideen mehr. Beschäftige mich aber auch erst 3 Monate mit dieser Materie, bin also noch sehr unerfahren.
Hat jemand noch einen Tipp für mich?
Freue mich auch über hinweise wo man mehr nachlesen kann.
Danke für jede Nachricht.
Gruß
Sunun