Results 1 to 10 of 24

Hybrid View

  1. #1
    Join Date
    Aug 2006
    Posts
    23
    Plugin Contributions
    0

    Default Can't access my data MySql data base

    For some strange reason the installer isn't letting me connect to my data base. I keep getting error messages that aren't always the same. I verified with Ipowerweb through their live chat that I was to use localhost, username and password, but it doesn't want to connect me. The data base is created. Then a very strange thing happened.

    I called my data base db1 and set my username=vivictor and password after playing around and talking to support I just gave up and closed the installer. Then I found that the installer had created a database called zen and it had installed the cart files.

    Because this happened before I could set up the store and the administration I can't access the admin. I then tried to install again after uploading the zc_install files and still had the same problem. I found out that the mysql data base doesn't like long usernames or passwords so I tried shortening them but no joy.

    I don't think I am missing any files. Perhaps unless there is a simple solution I will just upload everything again.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Can't access my data MySql data base

    Zen Cart does not create any databases on its own. It expects you to have created one before running the installation ... and simply asks you to supply the security information in order to access it.

    You don't need to re-upload anything, but you could start fresh by going to your ipowerweb control panel, delete the "db1" and "zen" databases you mentioned (if they're not used for anything else). Then create a new database, username, password. Write down the database-host-name/server-name required to access the database.

    Then continue by re-running the zc_install and choosing "Install" from the System Inspection page. Then explain exactly which errors you encounter.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Aug 2006
    Posts
    23
    Plugin Contributions
    0

    Default Re: Can't access my data MySql data base

    Thank you so much for such a quick reply. I did create a data base on Ipowerweb but the install program could not access it. I tried every possible solution including Ipowerweb live chat. Everything seemed ok.

    I understood everything up till 'choosing "Install" from the System Inspection page.' I have been in the 'Install' panel quite a lot and I have not a clue how I access this. I'm sure I'm doing something stupid, but really I tried so many things before I decided to bother you. I do not like to ask stupid questions.

    Thanks again for your patience and prompt rerply.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Can't access my data MySql data base

    Quote Originally Posted by Roon
    I understood everything up till 'choosing "Install" from the System Inspection page.'
    Please explain how you are "installing" Zen Cart.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Aug 2006
    Posts
    23
    Plugin Contributions
    0

    Default Re: Can't access my data MySql data base

    I'm not sure, since the loader seems to have a mind of it's own. I noticed that no one seems to have ever had my problem. ( I read FAQs). since the loader strands me in the middle of it's operation I am not really sure what I can add to my explanation.

    Logic would say that since I am the only one that seems to have experienced this problem it must be something wrong that I did.

  6. #6
    Join Date
    Aug 2006
    Posts
    23
    Plugin Contributions
    0

    Default Re: Can't access my data MySql data base

    I followed these instructions...deleted the data base, made a new one, deleted users and passes and made a new one. I set all the permissions to 'all'. then I received this error message. "Access denied for user: 'vic@localhost' (Using password: YES) more info... "( this of course said I had to have the right data base name, Username and pass which I had just created).

    As usual I get blocked here where the installer says it failed to connect to my MySql server. This time it didn't make the table. I went into MyAdmin and it wasn't there this time.

 

 

Similar Threads

  1. can I have 3 stores with one data base?
    By touchclothing in forum General Questions
    Replies: 2
    Last Post: 15 Sep 2008, 04:01 AM
  2. Direct access to MySQL Data
    By zigzak in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 1 Jun 2006, 01:18 PM

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