Checking database: failed - could not create database
Attempting to install to remote server for first time.
Successfully installed on 3 XAMPP servers, two Windows and one Macintosh.
Target for installation is a subdomain. I have used it to evaluate a great many CMS products in the last few months, most recently WordPress. No problems.
Passwords are not strong, but MODx shouldn’t care as long is it’s OK with the MySQL and Apache servers.
Fails also when no database exists. Failure is immediate.
Interested in whether there is logging available to help nail this down so I can open up the site.
I will supply any additional info. Please ask direct, detailed questions.
The two most likely problems are:
1. You didn’t give the correct database user/password during the install.
2. You don’t have the authority to create a new database via code (this is fairly common). In that case, you just need to create the database yourself (e.g. in PhpMyAdmin). You don’t need to create any tables or records -- just the empty DB.
Unfortunately my hosting company have multiple hardware issues today, so I can’t do anything.
You didn’t give the correct database user/password during the install.
I honestly don’t know what else to do to satisfy this suggestion. I created a new user, assigned it as admin for the database and entered the new password - many times! The host requires that the username be entered as prefix_username. I have tried it without the prefix.
You don’t have the authority to create a new database via code
You might be right, though I always give the SQL admin all rights that PHPMyAdmin allows to give.
Again:It passes the collation phase, so the user is good. I assume an error would occur in the collation check if it weren’t
It sounds very much like number two. The odds are that if you just create the empty MODx db, you’ll be fine.
