Guest Posted April 23, 2010 Share Posted April 23, 2010 I'm attempting to instal v 2.2 on my home pc running windows 7 and using easyphp. For some reason I get to the database server and can't get any further. The database server is set to localserver, username to root, password blank and the database name is correct.I've changed the register globals to on. When I click continue nothing at all happens. The orange box comes up with testing database connection and then that's it. No error message it just hangs there. Any idea what I've done wrong? Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 23, 2010 Share Posted April 23, 2010 Do you have MySQL installed on your PC? Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Guest Posted April 23, 2010 Share Posted April 23, 2010 yep easy php has v5.1.43 Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 23, 2010 Share Posted April 23, 2010 The database server is set to localserver There is no such thing. It should read 'localhost' Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Guest Posted April 23, 2010 Share Posted April 23, 2010 sorry it is set to localhost. That's what happens when you try to do a few things at once. Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 23, 2010 Share Posted April 23, 2010 Go to a command line and enter the following: mysql --user=root What is the result? Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Guest Posted April 23, 2010 Share Posted April 23, 2010 In phpmyadmin I clicked on SQL and then copied and pasted that in. I got this #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql --user=root' at line 1 Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 23, 2010 Share Posted April 23, 2010 In phpmyadmin I clicked on SQL and then copied and pasted that in. I got this #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql --user=root' at line 1 That's because I didn't tell you to use phpMyAdmin. I told you to go to a command line. THAT IS A WINDOWS COMMAND LINE Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Guest Posted April 23, 2010 Share Posted April 23, 2010 oops sorry. I get "my sq"l doesn't recognise it [or mysql isn't recognised] as an internal or external command, program or archive or executable somethings. (Spanish computer so that's a rough translation) Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 23, 2010 Share Posted April 23, 2010 oops sorry. I get "my sq"l doesn't recognise it [or mysql isn't recognised] as an internal or external command, program or archive or executable somethings. (Spanish computer so that's a rough translation) That tells me that mySQL is not installed on your computer, or the path to it is not included in the system path. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Guest Posted April 23, 2010 Share Posted April 23, 2010 Well that sounds like a 2 bottle of red wine problem. Think I'll have to uninstall tomorrow and reinstall from the beginning following the instrucitons carefully. The annoying thing is I've followedc the same instructions twice before on 2 different computers. Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 23, 2010 Share Posted April 23, 2010 And I know squat about easy php so I may be way off base. I'm not even sure that easy php installs mySQL in the conventional manner so it may not provide the command line tools. But then, I have NEVER suggested to anyone that they install on a local pc, even for testing. Just too much is different. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Guest Posted April 24, 2010 Share Posted April 24, 2010 I live in the south of spain where the internet is up and down more often than a wh***´s drawers! A heavy cloud, bad weather, power outage, or any other reason and it´s down. It´s been down for a few days in the past which is so frustrating. For fiddling with the STS templates it´s quicker to test locally. Plus I can still work on it as long as I have power. All I know about easyphp is that it´s recommended on a set of ´how to test locally´ instructions I found in the contributions. Guess I should have a scout around for another alternative and see if that´s the problem, or if it is something I'm doing. Link to comment Share on other sites More sharing options...
sereleg Posted June 5, 2010 Share Posted June 5, 2010 Hello I have the same problem, I did provide the Database Server=Localhost, username, Password and Database Name=osCommerce on Windows vista and when click on continue Testing database connection got stuck for ever. I have MySql 5.1 installed and verify using comand mysql --user=root Which respond access denied for user root... Please any ideas to solve this? I check the permission of catalog/install folder and is set to read but, does this read only permission has to do anything with the installation process? MySql 5.1 php 5.32 APACHE 2.2 OS Windows Vista Link to comment Share on other sites More sharing options...
meadowcow Posted June 28, 2010 Share Posted June 28, 2010 Database Server=Localhost try to use Database Server=mysql 'localhost' doesn't work for me, I try 'mysql' and it can continue the install process. Link to comment Share on other sites More sharing options...
ngiesingwang Posted September 30, 2010 Share Posted September 30, 2010 Database Server=Localhost try to use Database Server=mysql 'localhost' doesn't work for me, I try 'mysql' and it can continue the install process. This cant be work...i tried the mysql --user=root in my command prompt there and message show below: "Error 1045 (28000): Access denied for use 'root'@'localhost' (using password: NO)" How to solve this problem? Please help... 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.