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
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.
@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
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.
@greengoatmedia I did create the database myself and I do have access to it.
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!