-
- 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.
-
- 24,544 Posts
Most likely, you’ll have to create the empty DB yourself in phpMyAdmin before you can proceed.
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.
-
- 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.
-
- 9 Posts
I called HostMonster & worked it out. Thank all.