We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 37815
    • 25 Posts
    Hi, I am new to MODx and tried to install it today. I have set up a database and uploaded the files, setup went smoothly until I got to the Connection character set & Collation section. I put my correct details in but got this error:

    Checking database: MODX could not create your database. Please manually create your database and then try again.

    What am I doing wrong?

    Thanks

    B
      • 20413
      • 2,877 Posts
      Seems like you have to create it manually as the user you connecting with doesn't have enough permissions.

      A tip create the database with utf8 and collation utf8_general_ci
      Can save you from trouble as most things are using utf8.
        @hawproductions | http://mrhaw.com/

        Infograph: MODX Advanced Install in 7 steps:
        http://forums.modx.com/thread/96954/infograph-modx-advanced-install-in-7-steps

        Recap: Portland, OR (PDX) MODX CMS Meetup, Oct 6, 2015. US Bancorp Tower
        http://mrhaw.com/modx_portland_oregon_pdx_modx_cms_meetup_oct_2015_us_bancorp_tower
        • 36525
        • 47 Posts
        @bridgetdesigns Did you create the database yourself? Do you have access to it?
          Robert Tobys
          Managing Partner
          Green Goat Media
          916.405.1279

          Skype: roberttobys
          • 17667
          • 108 Posts
          Double-check username and password settings for database and make sure the user has full permissions.

          And I would second mrhaw on switching collation to utf8. You can do this with phpMyAdmin by selecting the database and going to the Operations tab.
            • 37815
            • 25 Posts
            @greengoatmedia I did create the database myself and I do have access to it.
              • 37815
              • 25 Posts
              update - I deleted everything and started again and this time it worked! Not sure what I was doing wrong before as I am sure I did them same this time - but all installed and working perfectly now. Thanks for your help guys!