If there is an "." in the Tabelprefix
you will get

Failed to CREATE a test table on your database server with the command CREATE TABLE {drupal_install_test} (id int NULL). The server reports the following message: SQLSTATE[42000]: Syntax error or access violation: 1142 CREATE command denied to user 'USER'@'localhost' for table '22_drupal_install_test'.

Also with correckt login data ;)


Damien Tournoud’s picture

Category: bug » support

I assume that your prefix is something like "something.22_"? If so, the culprit is probably your grants setup on the MySQL side, check that the user you are using has the right to create tables in the target database.

ulfh10’s picture

My Präfix was "drupal7.22_" and the installer couldn't create any db.
But if I log in manual I could create via SQL command, but this was without präfix because I don't think on it ^^.

Jooblay.com’s picture

MySQL does not allow . in your username or database name. Right?

I would use a database syntax that is more version based off your development like if your domain is example.com create excom_v1 as the user and excomv1_datestamp as the database name. The main syntax being the first 2 letters of the first word followed by the domain prefix.

Just a note:)

bryanbraun’s picture

Issue summary: View changes
Status: Active » Closed (works as designed)

As has been said before, MySql doesn't support the period in table names. Technically, it's possible when the name is escaped in queries, but it's still not recommended, especially, when a simple renaming can fix the issue. See this question for more information: http://stackoverflow.com/questions/776123/does-mysql-allows-to-create-da...

Since the "support request" was addressed, I'm closing this issue.