Category: MySQL

Set up PHP remote debugging with XDebug and an IDE — `xdebug.remote_host` / `remote_port` plus an SSH tunnel pattern.

Return a common post-login redirect target in Django Allauth without specifying a SocialAccount — how `LOGIN_REDIRECT_URL` behaves and how to override it.

If a Django MySQL connection still hits 'No DB engine substitution' despite setting `ENGINE` to `django.db.backends.mysql`, here is the root cause and fix.

When trying to connect MySQL Client 8.0 to MySQL 5.6, DataGrip displays an error message: "[08S01] Communications link failure java.io.EOFException: SSL peer shut down incorrectly," and the connection fails.

If you encounter the django.db.utils.InterfaceError: "(0, '')" error When this error occurs intermittently during get operations depending on the table or record, it might be due to a mismatch in the connection character encoding.

If a Django project that has been working until now fails to start after a long time with the following error: ``` version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined ```

While managing the root user with the mysql_user module in Ansible, I found that I was no longer able to grant privileges to other users.

Restart a halted replication on AWS RDS MySQL. Includes `CHECK TABLE` for MyISAM tables and the skip/resume operations on the replica side.

This isn't a completely quantitative discussion, but...

Background I'm creating a full-text index with bigrams in InnoDB on MySQL 5.6. However, when I tried to search for the term "TWIN,"