Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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 ;)
Comments
Comment #1
Damien Tournoud CreditAttribution: Damien Tournoud commentedI 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.Comment #2
ulfh10 CreditAttribution: ulfh10 commentedMy 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 ^^.
Comment #3
Jooblay.net CreditAttribution: Jooblay.net commentedMySQL 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:)
Comment #4
bryanbraun CreditAttribution: bryanbraun commentedAs 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.