We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 11579
    • 9 Posts
    I’m new to setting up MODx, though I’ve administered MODx websites. I am hung up in the installation on the "Connection Info Page". I got through "Server Connection & Login", but I can’t seem to get passed "Database Info". No matter what I enter i receive a message "Checking database: failed - could not create database".

    Database name:
    Table prefix:
    Connection method:
    Collation:

    The default Database Name & Prefix are: modx & modx_. I’ve trued that & any number of combos using the Name & Prefix I set up the MYSQYL database with. I’ve tried Connection Method as both "Set Character Set" & "Set Name" no difference. And I’ve tried Collation to: utf8_general_ci (which is the defualt) & utf8_unicode_ci (which is what my database is step up with).

    Right now I’m simply spinning in circles, trying variations of the same things over & over. HELP! My web host is Hostmonster.

    Any suggestions would be appreciated.
    • The character set and collations have nothing to do with this problem. In fact, you cannot select one until the database connection is made and MODx can determine what your database will support. Likewise neither the connection method nor the table prefix has any effect on the connection to the database at this point; these values are needed for creating the config.inc.php file that will be used later and for creating the tables in the database.

      If you have a database created already, then you just need to have the correct server, database name, login and password to access the database. If the database is not found, then MODx will try to create it, but if your database user does not have "create" permissions it won’t be able to.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 3749
        • 24,544 Posts
        Most likely, you’ll have to create the empty DB yourself in phpMyAdmin before you can proceed.
          Did I help you? Buy me a beer
          Get my Book: MODX:The Official Guide
          MODX info for everyone: http://bobsguides.com/modx.html
          My MODX Extras
          Bob's Guides is now hosted at A2 MODX Hosting
        • using the Name & Prefix I set up the MYSQYL database with
          This looks like you used the prefix as part of the database name. That’s not what it’s for; it is for MODx to use when creating the tables to prevent accidental collisions with other tables in the same database. So the site_content table will get named modx_site_content; the same with all the rest of the MODx tables.
            Studying MODX in the desert - http://sottwell.com
            Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
            Join the Slack Community - http://modx.org
            • 11579
            • 9 Posts
            Thanks guys. That was all really helpful info, but still hasn’t quite solved the problem. I did set up a new database (I’ve now set up 2) Though I haven’t set up any tables or subsequent data. I have enabled all access privileges.
              • 11579
              • 9 Posts
              I called HostMonster & worked it out. Thank all.
                • 52632
                • 2 Posts
                Quote from: gwpolarity at Jun 27, 2009, 12:20 AM
                I called HostMonster & worked it out. Thank all.
                How could you fix it?