Re: Still got issue with 'odbc' user

From: Date: Mon, 21 Jun 2010 15:45:54 +0000
Subject: Re: Still got issue with 'odbc' user
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-30162@lists.php.net to get a copy of this message
Hi Jacob, Jacob wrote: > Still getting the following error although now created a specific user > that granted all privileges to for the specific database, using PHPMyAdmin, > and the error returned is still the following: > (Problem: Access denied for user 'ODBC'@'localhost' (using password: NO) I bet the MySQL connection fails because of uninitialized variables, otherwise you'd see your passed username in the error message ('root'@'localhost') instead of ODBC. Could you try the following instead to connect to MySQL: [CODE] $dbServer = "localhost"; $dbUser = "root"; $dbPass = "root"; $dbName = "YOURDB"; $conn = mysql_connect($dbServer, $dbUser, $dbPass); if ($conn){ $res = mysql_select_db($dbName); if ($res){ print "Connection established"; } else { print "Selecting db failed"; } } else { print "Connection failed with ".mysql_error(); } [/CODE] Could you give us some more info about your file structure of your web? Especially, where are the $my... variables initialized used in the mysql_connect() call? Best regards, Sascha -- Freundliche Grüße / Kind regards, Sascha Meyer -------------------------------------------------- EE: http://www.experts-exchange.com/M_761556.html ZCE: http://www.zend.com/en/yellow-pages#show-ClientCandidateID=ZEND011290 GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01

« previous php.windows (#30162) next »