Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2006
    Posts
    74
    Plugin Contributions
    0

    Default how to create mysql database

    I went into my cpanel and created a new database.
    Then I created a user name and password
    Then I add the user name to the database and this is what is generated

    Connection Strings
    Perl $dbh = DBI->connect("DBI:mysql:acmearti_acme:localhost","acmearti_acme","<PASSWORD HERE>");
    PHP $dbh=mysql_connect ("localhost", "acmearti_acme", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
    mysql_select_db ("acmearti_acme");

    So in zencart 3.7 setup im at the database setup tab and I have no idea what to put in the tabs. Every thing I try gets an error.
    Here is a sceen grab of the 2 screens side by side

  2. #2
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: how to create mysql database

    localhost

    username
    password
    then the name you gave the database
    Zen cart PCI compliant Hosting

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

    Default Re: how to create mysql database

    so is it like this
    store identifier localhost
    Database host ???
    Database username acme
    database password password
    database name acme

  4. #4
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: how to create mysql database

    no its like this

    store identifier zen_(db prefix if you want one )
    Database host localhost
    Database username acme
    database password password
    database database name
    Zen cart PCI compliant Hosting

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

    Default Re: how to create mysql database

    ok looks like the settings are correct but I still get this error


    * Connection to Database failed
    Access denied for user 'acme'@'localhost' (using password: YES)

  6. #6
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: how to create mysql database

    if this is cpanel the db name will be
    acme_dbname
    if you created a username it will be
    acme_username
    Zen cart PCI compliant Hosting

  7. #7
    Join Date
    Aug 2006
    Posts
    74
    Plugin Contributions
    0

    Default Re: how to create mysql database

    you rock once again. Worked

 

 

Similar Threads

  1. How can I tell which Mysql database my store is using....
    By BobBobberson in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 20 Oct 2009, 06:49 AM
  2. How do I create mysql db on localhost machine?
    By dml311071 in forum Installing on a Windows Server
    Replies: 2
    Last Post: 24 Sep 2007, 09:54 AM
  3. Exactly how do I back Up a MySql database?
    By larryhyman in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 17 Apr 2007, 03:22 PM

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