Page 1 of 2 12 LastLast
Results 1 to 10 of 15
  1. #1
    Join Date
    Sep 2011
    Location
    Toronto, Ontario, Canada
    Posts
    290
    Plugin Contributions
    0

    Default Having trouble installing on local wampserver2.0

    Hi folks,

    I am trying to install zencart on my local machine, I downloaded wamp 2.3, it shows different interface than the tutorial How to set up a Wamp5 Server and install Zencart on your PC so I downloaded 2.0 and install it again. I followed the steps in the instruction but don't see where to set root password in phpMyAdmin, so I leave the password as default blank, and then continue to install zencart, I got the following error:

    0 Install Error: Could not connect to the Database
    in:
    [DROP TABLE IF EXISTS upgrade_exceptions;]

    Can anyone give me some clues? Thank you ver much.


    I'm using zencart version 1.3.9

  2. #2
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: Having trouble installing zencart on local wampserver2.0

    Did you create database before trying to install zencart or is it that you have been unable to create phpmyadmin password etc first?

  3. #3
    Join Date
    Sep 2011
    Location
    Toronto, Ontario, Canada
    Posts
    290
    Plugin Contributions
    0

    Default Re: Having trouble installing zencart on local wampserver2.0

    Quote Originally Posted by misty View Post
    Did you create database before trying to install zencart or is it that you have been unable to create phpmyadmin password etc first?
    Thanks.

    Maybe this is the reason. I thought the DB would be created during/after the zencart installation.

    The error message seems to tell me that connection has problem though because when I tried it again I also see this error:
    Connection to Database failed
    Host 'localhost' is not allowed to connect to this MySQL server

  4. #4
    Join Date
    Sep 2011
    Location
    Toronto, Ontario, Canada
    Posts
    290
    Plugin Contributions
    0

    Default Re: Having trouble installing on local wampserver2.0

    Another finding:

    When I try to open phpMyAdmin, it rejects me now:

    it opens a window with URL:http://localhost/phpmyadmin/ (I also tried http://127.0.0.1/phpmyadmin/, same error)

    #1130 - Host 'localhost' is not allowed to connect to this MySQL server


    How to fix it?

    Thanks

  5. #5
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: Having trouble installing on local wampserver2.0

    Wamp/phpmyadmin..suggest you visit
    http://forum.wampserver.com/read.php?2,14143

    You must create database BEFORE you try and install zencart
    into wamp and or paid webhosting.

  6. #6
    Join Date
    Sep 2011
    Location
    Toronto, Ontario, Canada
    Posts
    290
    Plugin Contributions
    0

    Default Re: Having trouble installing on local wampserver2.0

    Quote Originally Posted by misty View Post
    Wamp/phpmyadmin..suggest you visit
    http://forum.wampserver.com/read.php?2,14143

    You must create database BEFORE you try and install zencart
    into wamp and or paid webhosting.
    Thank you. The problem is I can't get into phpMyAdmin now, it keeps saying:

    #1130 - Host 'localhost' is not allowed to connect to this MySQL server

    Even after I uninstalled it and reinstall the wamp server again.

  7. #7
    Join Date
    Sep 2011
    Location
    Toronto, Ontario, Canada
    Posts
    290
    Plugin Contributions
    0

    Default Re: Having trouble installing on local wampserver2.0

    I have been able to change the root password using console, but wampserver still doesn't allow me to open phpMyAdmin.

  8. #8
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: Having trouble installing on local wampserver2.0

    http://localhost/phpmyadmin/
    is url to access wamp phpmyadmin.

    This is really a wamp support problem, not zencart.
    Suggest you visit wamp forums/support for more help.
    Return here if you require further help with zencart.

  9. #9
    Join Date
    Sep 2011
    Location
    Toronto, Ontario, Canada
    Posts
    290
    Plugin Contributions
    0

    Default Re: Having trouble installing on local wampserver2.0

    Quote Originally Posted by misty View Post
    http://localhost/phpmyadmin/
    is url to access wamp phpmyadmin.

    This is really a wamp support problem, not zencart.
    Suggest you visit wamp forums/support for more help.
    Return here if you require further help with zencart.
    I fully understand and agree that this is a wamp problem, specifically mySQL problem, I just couldn't get help from there and I really like to get help from here, just like any time before.

    I successfully changed root password, however, when I tried to enter phpMyAdmin again, I received another error which you can see in my attachment:
    MySQL said: Documentation
    #1045 - Access denied for user 'root'@'localhost' (using password: NO)


    I thought maybe password messes up so I go to MySQL console from wampserver, it prompts me for root password, and I can enter it with the password!!!

    Then why I was denied access?

    I do notice the error message contains something like using password: NO, maybe I should change it to YES? but I can't go back to the phpMyAdmin now, that's the problem!

    I hope someone can shed me more light, I am a newbie to MySQL, so inconvenient compared to SQL.

    Thanks lots in advance.

  10. #10
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: Having trouble installing on local wampserver2.0


 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Having issue on local wamp set up
    By mdivk in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 19 Feb 2012, 09:32 AM
  2. Having trouble installing stock by attributes
    By dreday42 in forum Setting Up Categories, Products, Attributes
    Replies: 9
    Last Post: 8 Mar 2011, 04:15 AM
  3. Having trouble installing the installer
    By top hatt in forum Installing on a Windows Server
    Replies: 2
    Last Post: 17 Feb 2010, 12:15 PM
  4. Having trouble installing on localhost.
    By gaffettape in forum Installing on a Windows Server
    Replies: 4
    Last Post: 12 May 2009, 12:00 PM
  5. Having Trouble installing ZC_install
    By andrewthai in forum Installing on a Windows Server
    Replies: 1
    Last Post: 26 Sep 2008, 07:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR