drrnlav Posted July 27, 2008 Share Posted July 27, 2008 Hi I get the following error.. A test connection made to the database was NOT successful. The error message returned is: Access denied for user 'yut876'@'Serv0001.avagoo.com' (using password: YES) Please click on the Back button below to review your database server settings. If you require help with your database server settings, please consult your hosting company. I have checked the configure.php and used the settings within that file. Still no luck. Any suggestions? Thanks Darren Link to comment Share on other sites More sharing options...
web-project Posted July 27, 2008 Share Posted July 27, 2008 Access denied for user 'yut876'@'Serv0001.avagoo.com' (using password: YES) re-check the mysql database access information Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you. Link to comment Share on other sites More sharing options...
Guest Posted July 27, 2008 Share Posted July 27, 2008 Hi I get the following error.. A test connection made to the database was NOT successful. The error message returned is: Access denied for user 'yut876'@'Serv0001.avagoo.com' (using password: YES) Please click on the Back button below to review your database server settings. If you require help with your database server settings, please consult your hosting company. I have checked the configure.php and used the settings within that file. Still no luck. Any suggestions? Thanks Darren Did you create the database before installing? Link to comment Share on other sites More sharing options...
drrnlav Posted July 27, 2008 Author Share Posted July 27, 2008 Hi I followed the instructions by www.stevebraithwaite.com. I understand what I have to do. This is my current problem (I am also asking my web hosting company to resolve this issue).... A test connection made to the database was NOT successful. The error message returned is: Access denied for user 'eboodcom_alpha'@'Serv0001.avagoo.com' (using password: YES) Please click on the Back button below to review your database server settings. If you require help with your database server settings, please consult your hosting company. These were my settings (i created a new database called alpha) database Server: Serv0001.avagoo.com Database username eboodcom_alpha Password: ********** Database Name: eboodcom_alpha Persistent Connections: ticked Session Storage: database any suggestions? Link to comment Share on other sites More sharing options...
Guest Posted July 27, 2008 Share Posted July 27, 2008 Hi I followed the instructions by www.stevebraithwaite.com. I understand what I have to do. This is my current problem (I am also asking my web hosting company to resolve this issue).... A test connection made to the database was NOT successful. The error message returned is: Access denied for user 'eboodcom_alpha'@'Serv0001.avagoo.com' (using password: YES) Please click on the Back button below to review your database server settings. If you require help with your database server settings, please consult your hosting company. These were my settings (i created a new database called alpha) database Server: Serv0001.avagoo.com Database username eboodcom_alpha Password: ********** Database Name: eboodcom_alpha Persistent Connections: ticked Session Storage: database any suggestions? Does that information fit with the information you gave in your first post? The username is different, don't know about the database name. Link to comment Share on other sites More sharing options...
drrnlav Posted July 27, 2008 Author Share Posted July 27, 2008 Hi I have a few different databases, all of which are blank. I have also edited the configure.php with the necessary username and password. Is this right? Link to comment Share on other sites More sharing options...
drrnlav Posted July 27, 2008 Author Share Posted July 27, 2008 I also have this problem (its probably all related)...... Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'eboodcom_yut876'@'localhost' (using password: YES) in /home/eboodcom/public_html/includes/functions/database.php on line 19 Unable to connect to database server! The code is.... <?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 © 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); } if ($$link) mysql_select_db($database); return $$link; } function tep_db_close($link = 'db_link') { global $$link; return mysql_close($$link); } function tep_db_error($query, $errno, $error) { die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>'); } function tep_db_query($query, $link = 'db_link') { global $$link; if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG); } $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error()); if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { $result_error = mysql_error(); error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG); } return $result; } function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') { reset($data); if ($action == 'insert') { $query = 'insert into ' . $table . ' ('; while (list($columns, ) = each($data)) { $query .= $columns . ', '; } $query = substr($query, 0, -2) . ') values ('; reset($data); while (list(, $value) = each($data)) { switch ((string)$value) { case 'now()': $query .= 'now(), '; break; case 'null': $query .= 'null, '; break; default: $query .= '\'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ')'; } elseif ($action == 'update') { $query = 'update ' . $table . ' set '; while (list($columns, $value) = each($data)) { switch ((string)$value) { case 'now()': $query .= $columns . ' = now(), '; break; case 'null': $query .= $columns .= ' = null, '; break; default: $query .= $columns . ' = \'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ' where ' . $parameters; } return tep_db_query($query, $link); } function tep_db_fetch_array($db_query) { return mysql_fetch_array($db_query, MYSQL_ASSOC); } function tep_db_num_rows($db_query) { return mysql_num_rows($db_query); } function tep_db_data_seek($db_query, $row_number) { return mysql_data_seek($db_query, $row_number); } function tep_db_insert_id() { return mysql_insert_id(); } function tep_db_free_result($db_query) { return mysql_free_result($db_query); } function tep_db_fetch_fields($db_query) { return mysql_fetch_field($db_query); } function tep_db_output($string) { return htmlspecialchars($string); } function tep_db_input($string) { return addslashes($string); } function tep_db_prepare_input($string) { if (is_string($string)) { return trim(tep_sanitize_string(stripslashes($string))); } elseif (is_array($string)) { reset($string); while (list($key, $value) = each($string)) { $string[$key] = tep_db_prepare_input($value); } return $string; } else { return $string; } } ?> Link to comment Share on other sites More sharing options...
web-project Posted July 27, 2008 Share Posted July 27, 2008 Hi I have a few different databases, all of which are blank. I have also edited the configure.php with the necessary username and password. Is this right? did you set permission for user to access the specific database? Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.