tolrodco Posted June 2, 2004 Share Posted June 2, 2004 Hi, I'm having a problem when I installing oscommerce, I keep getting the following error: 1044: Access denied for user: 'xhiyldom_tolrodc@localhost' to database 'osCommerce' Does anyone have an idea of what I'm doing wrong? Thanks! Quote Link to comment Share on other sites More sharing options...
vengavenga Posted June 2, 2004 Share Posted June 2, 2004 Hi, It sounds like you've just given it wrong username and password for the database. I'm guessing the following from what you've posted: Your tch username is "xhiyldom" You've set up the database "oscommerce" And you've added a user to the dayabase called "tolrodc" More than likely, your full database name is actually "xhiyldom_oscommerce" Hope that helps Quote Link to comment Share on other sites More sharing options...
tolrodco Posted June 2, 2004 Author Share Posted June 2, 2004 Thanks, it didn't register in my head until you said that it would be the "xhiyldom_oscommerce". Besides that it was too early in the morning for me! LOL! Thanks for the help! Quote Link to comment Share on other sites More sharing options...
vengavenga Posted June 2, 2004 Share Posted June 2, 2004 No problem - anytime Quote Link to comment Share on other sites More sharing options...
TomMarch Posted February 25, 2005 Share Posted February 25, 2005 Hi, I am having a similar problem with deined access to the database when installing oscommerce. I have carefully checked the username and password and dbase name (even deleted and re-set-up mysql dbase and user twice to no avail). The message I get is: Access denied for user: 'storeoz_store@server91.totalchoicehosting.com' (Using password: YES) Any help would be appreciated, thanks, Tom -- Quote Link to comment Share on other sites More sharing options...
TCH-Andy Posted February 25, 2005 Share Posted February 25, 2005 Hi Tom, Welcome to the Family looking on 91, the database name you have used seems to be "storeoz_storedb" not "storeoz_store" Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted February 25, 2005 Share Posted February 25, 2005 Welcome to the Family Tom and your new home! We really are like family here. So if you need anything, just ask your new family! We love to help Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted February 25, 2005 Share Posted February 25, 2005 Welcome to the family and forums Tom! Quote Link to comment Share on other sites More sharing options...
TomMarch Posted March 16, 2005 Share Posted March 16, 2005 Hi Guys thanks for your quick feedback. I didn't really expect it so I didn't check back till now I'm trying to get the store up and running today so here's where I am still at: The info I'm using is: host: store.ozline.com user: storeoz_store dbase: storeoz_storedb and I still get this message: Access denied for user: 'storeoz_store@server91.totalchoicehosting.com' (Using password: YES) I'll plug away at it today if anyone's online. Thanks again. It's nice to be supported! Tom -- Quote Link to comment Share on other sites More sharing options...
GroovyFish Posted March 16, 2005 Share Posted March 16, 2005 Hi Tom, Are you installing OSC from cpanel? I haven't done that before (I have only installed it manually) so I am unsure if the one-click install automatically creates the db for you... If you created the db, make sure you have added the user to the database. Also, for host, try using localhost. Quote Link to comment Share on other sites More sharing options...
TomMarch Posted March 17, 2005 Share Posted March 17, 2005 Hi Tom, Are you installing OSC from cpanel? I'm using the oscommmerce Web-based install. I created the dbase in cpanel's mySQL interface and added the dbase user. It looks like oscommerce adds the host itself. Any thing else? Thanks, Tom -- Quote Link to comment Share on other sites More sharing options...
GroovyFish Posted March 17, 2005 Share Posted March 17, 2005 I created the dbase in cpanel's mySQL interface and added the dbase user. It looks like oscommerce adds the host itself. <{POST_SNAPBACK}> Not to harp on this issue...but just to clarify, you created a database, and a database user, and then you added the user to the database? Many of people miss that last step. Double check your database password. The only reason I mention this is because not too long ago I was setting up a zen-cart and chose a long password for my database. And I was having difficulty getting the cart to connect. I changed the password to something shorter and it worked. I am not sure if PhpMyAdmin has a limit on number of characters and truncated my long password... I didn't have time to investigate so I went with the shorter password. (maybe a staff member can confirm?) If none of that works, PM me if you would like me to take a look at your config file. Quote Link to comment Share on other sites More sharing options...
TomMarch Posted March 17, 2005 Share Posted March 17, 2005 I will check all these again, but I have done them before with WordPress and it all went well. Where is the Config file located and I can check it. thanks a lot for your help! Tom -- Quote Link to comment Share on other sites More sharing options...
TCH-Thomas Posted March 17, 2005 Share Posted March 17, 2005 Welcome to the forums Tom. Quote Link to comment Share on other sites More sharing options...
GroovyFish Posted March 17, 2005 Share Posted March 17, 2005 Hi Tom, From what I can tell, you are installing OSC manually. Have you tried the one-click install in Cpanel for OSCommerce? I just tried it and it's pretty slick. You just tell it the name of the folder you want the store in, and the login and password you'd like for the admin section and it takes care of everything else... creates the database, user...everything. Looks like the only thing you might need to do is to modify the configure.php file to add SSL support (if you need that) Anyway...if I was going with OSC, that is what I would use....MUCH easier than doing it by hand! Quote Link to comment Share on other sites More sharing options...
GroovyFish Posted March 17, 2005 Share Posted March 17, 2005 By the way...the configure.php files are in /includes /admin/includes HTH! Quote Link to comment Share on other sites More sharing options...
TomMarch Posted March 21, 2005 Share Posted March 21, 2005 Dear GroovyFish, Thanks for your help. I've now discovered the one-click osCommerce in Cpanel and it's been great. I didn't know it was lurking there in the scripts library. Thanks for all your quick help, Tom -- Quote Link to comment Share on other sites More sharing options...
karlkablisk Posted May 3, 2006 Share Posted May 3, 2006 Hi everyone I'm new here. It looked like you guys were friendly and knowledgable about OScommerce so I wanted to see if I could get some help. When i go to my site i get this error Warning: mysql_connect(): Access denied for user: 'kablisk_osc1@localhost' (Using password: YES) in /home/kablisk0/public_html/store/includes/functions/database.php on line 19 Unable to connect to database server! site is www.kabliskkeep.com/store/ Oscommerece worked and then one day it was broken its been like that for a bit. the server changed usernames for the admin login. someone told me my old one wont work and i cant add it for some reason. any idea why the error is coming up? I'm fine with scrapping the whole thing (even though i had a lot listed on there) and re-installing osCommerce but i dont know how. I can do it with FTP? I use Cpanel is that easier? thanks TCH-Thomas made the link inactive. Quote Link to comment Share on other sites More sharing options...
TCH-Thomas Posted May 3, 2006 Share Posted May 3, 2006 Welcome to the forum, karlkablisk. Be sure that in MySql you 1 - created the database 2 - created a user 3 -added the user to the database (go back to MySql and find the Add user select the user and database, and then [bold]Add user to database[/bold]) Then to connect to the database in a script, use: host: localhost database: yourCpanelName_databaseName user: yourCpanelName_databaseUser password: mypassword Note: password is just as the password, do not add the CpanelName to it. If this doesn´t work, we can go from there. Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted May 3, 2006 Share Posted May 3, 2006 Welcome to the forum, karlkablisk Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted May 3, 2006 Share Posted May 3, 2006 Welcome to the forum, karlkablisk Quote Link to comment Share on other sites More sharing options...
Samrc Posted May 3, 2006 Share Posted May 3, 2006 Welcome to the forum! Quote Link to comment Share on other sites More sharing options...
karlkablisk Posted May 5, 2006 Share Posted May 5, 2006 thanks, i went into cpane and mysql and did the add database and add ueser thing but nothing worked. :/ If I gave you my login maybe you could see more clearly whats going on, my site is pretty much dead as it is wihtout me being able to access the database. Let me know if you dont mind helping me out with a PM and I'll give the info. I got this new error when trying to reinstall os commerce ---- Upgrade A test connection made to the database was NOT successful. The error message returned is: Host 's1.bandhoster.com' is not allowed to connect to this MySQL server 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. ------ another error i see is this Warning: mysql_connect(): Access denied for user: 'userName0@localhost' (Using password: YES) in /home/userName0/public_html/core/database-mysql.php on line 50 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/userName0/public_html/core/database-mysql.php on line 52 ------ see my login used to be "userName" but something happened and now its userName0 and im told i cant make userName again. :/ If i could just make "userName" again everything that was set to recognize that name would still get it, if not then everything needs to see the new username. Let me know what you think. thanks a lot guys - KKL Welcome to the forum, karlkablisk. Be sure that in MySql you 1 - created the database 2 - created a user 3 -added the user to the database (go back to MySql and find the Add user select the user and database, and then [bold]Add user to database[/bold]) Then to connect to the database in a script, use: host: localhost database: yourCpanelName_databaseName user: yourCpanelName_databaseUser password: mypassword Note: password is just as the password, do not add the CpanelName to it. If this doesn´t work, we can go from there. edit: not a good idea to post your cpanel username in the forum -th Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted May 5, 2006 Share Posted May 5, 2006 Remember when setting up a database that the following naming convention is used. database -- cpanelname_databasename user -- cpanelname_username Did you configure your db using this naming scheme? Quote Link to comment Share on other sites More sharing options...
karlkablisk Posted May 8, 2006 Share Posted May 8, 2006 can anyone give me an idea of how to make a "database.sql file" without using cpanel? For some reason when I use cpanel it says it made a new login (Im assuming thats what the database.sql file is, if it isnt someone please tell me what and how to make one i know i need that at least) but nothing is added. :/ thanks all - KKL Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted May 8, 2006 Share Posted May 8, 2006 I am not sure that you can. I could be wrong. You could open a ticket with the help desk and ask them. But the instructions are simple enough for creating them in cPanel. See the movie tutorial Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.