MySQL 'CREATE DATABASE' priviledges

I noticed on the page for ’Server Requirements’ ..

http://svn.modxcms.com/docs/display/revolution/Server+Requirements

under the heading ’MySQL Database Requirements’

that it says:

•CREATE DATABASE will allow new installs to create the database for you with the proper charset/collation.

the word ’proper’ there is what interests me.

Does this say I can SET the charset/collation of my choice?

I use the MySQL module in cPanel to create databases, users & set perms.

But I see no ’CREATE DATABASE’ option here. All I see is:

SELECT CREATE
INSERT ALTER
UPDATE DROP
DELETE LOCK TABLES
INDEX REFERENCES
CREATE TEMPORARY TABLES
CREATE ROUTINE

I would like to be able to set charset/collation during install.

And IF I am able to enable the ’CREATE DATABASE’ option/priviledge/perm, HOW would I go about setting charset/collation during installation?

Just use the install package, you’ll be able to set charset/collation on the second page!

I did.

But it only displayed my defaults. Would not allow me to make changes:

http://modxcms.com/forums/index.php/topic,43983.0.html

Is it a clean install?

Yeah.

One interesting thing is that I’m not able to do anything with directories from the ’Files’ tab.

In other words, I can’t delete files, or upload files or anything like that.

The option to delete the /setup directory after install did not work for me. I had to manually delete the directory (using linux/unix rm command from bash shell "rm -rf setup")

So maybe this problem is also affecting my database .. not allowing me to manipulate.

I dunno.

Most hosts (esp. those with CPanel or another control panel) don’t allow you to give CREATE privileges at the global level, which is required to CREATE DATABASE. You have to create the database with their system, then login to phpMyAdmin and alter the charset/collation on the database to the one you want. Then install MODx and it will create the tables using the charset/collation of the database.

worked.

It may be possible to create a user and give the user the correct permissions first, but most apps and control panels prefer that you create the user directly attached to a database with established permissions for that database.