Guest Posted April 30, 2004 Share Posted April 30, 2004 I am having problems connecting to the MySQL database Here is what I get when setting it up: Info: OS: Windows Server 2003 w/IIS 6.0 osCommerce: 2.2 Milestone 2 MySQL: 4.0.17 Link to comment Share on other sites More sharing options...
bluepony Posted April 30, 2004 Share Posted April 30, 2004 Have you created an empty database, added a user, and assigned that user to the database in MYSQL? I'd rather be flying! Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2004 Share Posted April 30, 2004 I created the database, dumped the osC tables to it. I just cant figure out how to add a user to the database...got me stumped... Link to comment Share on other sites More sharing options...
bluepony Posted April 30, 2004 Share Posted April 30, 2004 If you are using phpmyadmin, there should be an add user link. Although some hosting companies remove this option and you must go through their control panel to add a user. I'd rather be flying! Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2004 Share Posted April 30, 2004 I guess before I intsall PHPMyadmin I need to set up the initial user in MySQL.... this is right fromt he MYSql manual: mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; I am doing somethin like that at the cmd prompt a good mysql resource: MySQL Reference Manual So I added my user...I still get access denied...even for the default root account... Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2004 Share Posted April 30, 2004 so i have myphpadmin installed and running [not in the site I want the catalog but in the defualt site] and I dotn kow what to do now....???? Link to comment Share on other sites More sharing options...
bluepony Posted April 30, 2004 Share Posted April 30, 2004 Launch phpmyadmin. http://wheveryouinstalled/phpmyadmin Select your database and manage your users. It sounds like your user either does not exist or does not have full rights to the database. I'd rather be flying! Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2004 Share Posted April 30, 2004 Ok, I have this: sqluser localhost Yes ALL PRIVILEGES Yes Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2004 Share Posted April 30, 2004 so that would tell me that the user I am trying to put intot he osC setup should have access....but then again, even the root does not have access.... Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2004 Share Posted April 30, 2004 the current error: Can't connect to MySQL server on 'www.[the domain].com' (10060) what should I put in the host box...so far I have tried the local IP, the hostname, DNS nothing works Link to comment Share on other sites More sharing options...
Guest Posted May 1, 2004 Share Posted May 1, 2004 I am not finding any documentation on the step by step of how to set osCommerce...anyone got a quick link? Link to comment Share on other sites More sharing options...
zzfritz Posted May 1, 2004 Share Posted May 1, 2004 http://wiki.oscommerce.com/docsInstallNew But this does not offer server-specific advice on such things as how to create the database, create a user name and assign it a password. As suggested above, many hosting companies provide a control panel that has this facility. And hosts vary on the matter of how to identify the database server. Try 'localhost' or ask your hosting company. Finally, I notice your prior post that you "created the database, dumped the osC tables to it." But you should only create the database, and let the osC install create the tables. Link to comment Share on other sites More sharing options...
Guest Posted May 1, 2004 Share Posted May 1, 2004 I figured it out! I had gone through before and done the manual importing of the oscommerce.sql file into the database [via cmd line]...I couldnt get my server to display the PHP files when surfing the site...then I got that working...see the site below: [http://www.warrenonline.ca/tutorials/tutorial5/tut5_2.php] so I uninstalled MySQL, the admin utility [i somehow locked myself out, don't ask!] and then reinstalled everything... I went through the install.php screens and it worked! AMAZING... Thank you all that helped me out! [i will be needing help in the future with this, I can tell already!] Thanx! Retro77 Link to comment Share on other sites More sharing options...
Guest Posted May 1, 2004 Share Posted May 1, 2004 I have now put the second site onto the secure server and it works up to the point of confirmation. After you click the 'Confirm Order' button it takes me to an error page which reads as follows:- Warning: Cannot send session cookie - headers already sent by (output started at /homepages/46/d86206271/htdocs/secure1st/4printing/catalog/checkout_process.php:1) in /homepages/46/d86206271/htdocs/secure1st/4printing/catalog/includes/functions/sessions.php on line 67 Warning: Cannot send session cache limiter - headers already sent (output started at /homepages/46/d86206271/htdocs/secure1st/4printing/catalog/checkout_process.php:1) in /homepages/46/d86206271/htdocs/secure1st/4printing/catalog/includes/functions/sessions.php on line 67 Warning: Cannot add header information - headers already sent by (output started at /homepages/46/d86206271/htdocs/secure1st/4printing/catalog/checkout_process.php:1) in /homepages/46/d86206271/htdocs/secure1st/4printing/catalog/includes/functions/general.php on line 29 What do I need to do to ammend this. Link to comment Share on other sites More sharing options...
Guest Posted May 1, 2004 Share Posted May 1, 2004 Posted my mistake 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.