Mautic Community Forums

not able to connect to local xampp server to mysql database

not able to connect to local xampp server to mysql database



An error occurred while attempting to install the data: An exception occurred while executing ‘ALTER TABLE oauth1_request_tokens ADD CONSTRAINT FK_80F3C6EAA76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE’: SQLSTATE[HY000]: General error: 1025 Error on rename of ‘.markmas#sql-1aac_5f’ to ‘.markmasoauth1_request_tokens’ (errno: 13 “Permission denied”)

not able to connect to local xampp server to mysql database

An error occurred while attempting to install the data: An exception occurred while executing ‘ALTER TABLE oauth1_request_tokens ADD CONSTRAINT FK_80F3C6EAA76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE’: SQLSTATE[HY000]: General error: 1025 Error on rename of ‘.markmas#sql-1aac_5f’ to ‘.markmasoauth1_request_tokens’ (errno: 13 “Permission denied”)

Definitely a permissions issue… are you able to login to your local MySQL db using your root account?