To check whether SSL redirection is enabled or disabled in Magento using MySQL command line, you can execute the following SQL query:
SELECT * FROM core_config_data WHERE path LIKE '%web/secure/use_rewrites%';
If the value of the value column is set to 1, then SSL redirection is enabled. If the value is set to 0, then SSL redirection is disabled.
To disable SSL redirection in Magento using MySQL command line, you can execute the following SQL query:
UPDATE core_config_data SET value = 0 WHERE path = 'web/secure/use_rewrites';
After executing this query, you need to clear the Magento cache for the changes to take effect. You can do this by running the following command from the Magento root directory:
php bin/magento cache:clean
Note that it’s always recommended to take a backup of your database before making any changes.