k6kdk Posted August 13, 2006 Share Posted August 13, 2006 I have used phpMYSQL wiic is preloaded on my ISP via the CPANEL to establish a test database, for a test drive of oscommerce. I have loaded CALOLOG to ISp and all is OK when access by my web browser to install routines. BUT when i get to install screen : New Installation Database Import Please enter the database server information: I enter the data and hit continue and then get error: New Installation Database Import A test connection made to the database was NOT successful. The error message returned is: Access denied for user: '[email protected]' (Using password: YES) Please click on the Back button below to review your database server settings. I have tried every combination of passwrod and usernames. I have deleted users, and databas and reinstalled them, but always same erro??? Any Ideas to help me on theis?? Thanks -Dan K6KDK Link to comment Share on other sites More sharing options...
Guest Posted August 13, 2006 Share Posted August 13, 2006 can you log into your database with these username and password settings? Link to comment Share on other sites More sharing options...
k6kdk Posted August 13, 2006 Author Share Posted August 13, 2006 I can open phpMySQL and see that the database is there and run a query on it and enter a test field. ( I di this through cPanel anfter I have already looged in to Cpanel. but I can not do this from Catalog. It is as if the server is somehow configured to deny access to any inquiry from outside of CPanel ? I think it must be some sort of secuity issues with the way the ISP set up mySQL on their servers ??? Is that possible? -Dan Link to comment Share on other sites More sharing options...
Guest Posted August 13, 2006 Share Posted August 13, 2006 i doubt it very much. its more than normal for web browsers to write information to your database, it is in fact one of the principes of oscommerce. what you should do is to confirm that the username and password are correct. Check these values in cPanel. But I am very sure you are typing these incorrectly or maybe your privileges are not set to ALL for this user (this is a guess) Link to comment Share on other sites More sharing options...
k6kdk Posted August 13, 2006 Author Share Posted August 13, 2006 OK, I have gotten past that, by using the username and pasword for my account on the server. It will take that, but it will not take username and password (that I made the test database with!) The username and the passwoprd MUST be the same as the global username and password for the account on the web server. So it has loaded all necessary files,with some exceptions it could not find (looked like graphic gif file or something, it was about a hand full that it 10-12 files that it could not find. I looked at my test_database with phpMyAdmin, and all looks real good, it is populated with a bunch of stuff that looks right for the database load.. so tthe darn database IS there at this time BUT BUT. BUT NOW I have renamed the INSALL diretory, and when I run catalog I get: Warning: mysql_connect(): Access denied for user: 'root@localhost' (Using password: NO) in /usr/home/broc3341/public_html/catalog/includes/functions/database.php on line 19 Unable to connect to database server! SO more access/password error?? Note ->it says Using Password:NO<- This is very strange. Maybe I need to edit something in the includes/functions/database.php file to force it to use password. or maybe I just hard code in that password there??? -Dan Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.