- 🇬🇧United Kingdom steven jones
Either we've fixed this in the last 7 years, or MySQL 5.7 is community EOL'd anyway.
Do re-open if this is still an issue with the latest Provision.
Ran into a problem where MySQL 5.7 has changed the user table schema, dropping the Password field in place for authentication_string as can be seen in the following release notes - https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html
Symptoms show up with new sites and cloneing, I think it has to do with DB imports, see examples
Database import failed: ERROR 1210 (HY000) at[error]
line 21: Incorrect arguments to EXECUTE
or verbose
Importing database using command: mysql --defaults-file=/dev/fd/3 newsite [31.57 sec, 10 MB] [notice]
Database import failed: ERROR 1210 (HY000) at line 21: Incorrect arguments to EXECUTE [error]
[31.58 sec, 30.01 MB]
Returned from hook drush_db_provision_deploy [31.57 sec, 10 MB] [debug]
Changes made in drush_provision_drupal_pre_provision_deploy have been rolled back. [31.59 sec, 10 MB] [debug]
Dropping database newsite [31.59 sec, 10 MB] [notice]
Executing: mysql -u intntnllyInvalid -h 'localhost' -P '3306' -e "SELECT VERSION\(\)"
ERROR 1045 (28000): Access denied for user 'intntnllyInvalid'@'localhost' (using password: NO)
Executing: mysql -u intntnllyInvalid -h 'localhost' -P '3306' -e "SELECT VERSION\(\)"
ERROR 1045 (28000): Access denied for user 'intntnllyInvalid'@'localhost' (using password: NO)
Revoking privileges of newsite@localhost from
Closed: won't fix
3.9
DB Service
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Either we've fixed this in the last 7 years, or MySQL 5.7 is community EOL'd anyway.
Do re-open if this is still an issue with the latest Provision.