[12.x] Add option to disable MySQL ssl when restoring or squashing migrations (#55683)

andersonls · taylorotwell · web-flow · commit e0b397b7198b · 2025-05-09T09:54:17.000-05:00
* Add option to disable mysql ssl when loading or squashing migrations

* Update MySqlSchemaState.php

---------

Co-authored-by: Taylor Otwell &lt;taylor@laravel.com&gt;
diff --git a/src/Illuminate/Database/Schema/MySqlSchemaState.php b/src/Illuminate/Database/Schema/MySqlSchemaState.php
@@ -115,6 +115,11 @@ protected function connectionString()
             $value .= ' --ssl-ca="${:LARAVEL_LOAD_SSL_CA}"';
         }
 
+        if (isset($config['options'][\PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT]) && 
+            $config['options'][\PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] === false) {
+            $value .= ' --ssl=off';
+        }
+
         return $value;
     }
 
diff --git a/tests/Database/DatabaseMySqlSchemaStateTest.php b/tests/Database/DatabaseMySqlSchemaStateTest.php
@@ -70,6 +70,24 @@ public static function provider(): Generator
             ],
         ];
 
+        yield 'no_ssl' => [
+            ' --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_LOAD_PASSWORD}" --host="${:LARAVEL_LOAD_HOST}" --port="${:LARAVEL_LOAD_PORT}" --ssl=off', [
+                'LARAVEL_LOAD_SOCKET' => '',
+                'LARAVEL_LOAD_HOST' => '',
+                'LARAVEL_LOAD_PORT' => '',
+                'LARAVEL_LOAD_USER' => 'root',
+                'LARAVEL_LOAD_PASSWORD' => '',
+                'LARAVEL_LOAD_DATABASE' => 'forge',
+                'LARAVEL_LOAD_SSL_CA' => '',
+            ], [
+                'username' => 'root',
+                'database' => 'forge',
+                'options' => [
+                    \PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false,
+                ],
+            ],
+        ];
+
         yield 'unix socket' => [
             ' --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_LOAD_PASSWORD}" --socket="${:LARAVEL_LOAD_SOCKET}"', [
                 'LARAVEL_LOAD_SOCKET' => '/tmp/mysql.sock',

Original file line number	Diff line number	Diff line change
`@@ -115,6 +115,11 @@ protected function connectionString()`
`115`	`115`	`$value .= ' --ssl-ca="${:LARAVEL_LOAD_SSL_CA}"';`
`116`	`116`	`}`
`117`	`117`
	`118`	`+ if (isset($config['options'][\PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT]) &&`
	`119`	`+ $config['options'][\PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] === false) {`
	`120`	`+ $value .= ' --ssl=off';`
	`121`	`+ }`
	`122`	`+`
`118`	`123`	`return $value;`
`119`	`124`	`}`
`120`	`125`