Answered Installing 2.3.1 Database Errors

Quote from: benlbit at Jul 29, 2014, 01:15 AM

SHOWGRANTSFOR CURRENT_USER

Output:

GRANT USAGE ON *.* TO 'CRYSTA1_dba'@'%' IDENTIFIED BY PASSWORD 'sssssh!'
GRANT ALL PRIVILEGES ON `CRYSTA1\_modx`.* TO 'CRYSTA1_dba'@'%' WITH GRANT OPTION

I think there's a bug in the 2.3.1 installer.

Based on the script above, it is giving full rights to a schema called "_modx". Either that schema exists, or it doesn't.

If that schema exists (i.e. in PHPmySQLAdmin, it shows in the dropdown along with INFORMATION SCHEMA), then there is a bug with the installer and you should raise a bug.

If, on the other hand, your schema is something else, make sure you're not mixing up the table prefix and the schema name in installation.

When all that has been confirmed to be ok, then I'd suggest raising a bug through github.

Regards,
Tom

That definitely looks like you've confused the table prefix with the database name.

Quote from: sottwell at Jul 29, 2014, 07:17 AM

That definitely looks like you've confused the table prefix with the database name.

My Database is called CRYSTA1_Modx and my table prefix is called modx_.

Hi benlbit,

Glad to see you got it working! Congrats!

Regards,
Tom

Thank you to everyone for their time, input and assistance.

Quote from: benlbit at Jul 29, 2014, 08:18 AM

Thank you to everyone for their time, input and assistance.

You're very welcome. One thing that I'd like to think sets MODX apart from a lot of other online communities is the fact that we are very supportive and helpful. Susan is a perfect example of this.

Regards,
Tom

I just had the same problem today. Changing the table prefix to mx_ worked for me as well.