fix: show sql query to delete user if we have a private database

carlalexander · carlalexander · commit c9e57feadd78 · 2022-01-29T11:47:58.000-05:00
diff --git a/src/Command/Database/DeleteDatabaseUserCommand.php b/src/Command/Database/DeleteDatabaseUserCommand.php
@@ -71,7 +71,8 @@ protected function perform(InputInterface $input, OutputInterface $output)
 
         if (!$databaseServer['publicly_accessible']) {
             $output->newLine();
-            $output->important('The database user needs to be manually deleted on the database server because it isn\'t publicly accessible');
+            $output->important('The database user needs to be manually deleted on the database server because it isn\'t publicly accessible. You can use the following query to delete it');
+            $output->writeln(sprintf('DROP USER IF EXISTS %s@\'%%\'', $user['username']));
         }
     }
 }

Original file line number	Diff line number	Diff line change
`@@ -71,7 +71,8 @@ protected function perform(InputInterface $input, OutputInterface $output)`
`71`	`71`
`72`	`72`	`if (!$databaseServer['publicly_accessible']) {`
`73`	`73`	`$output->newLine();`
`74`		`- $output->important('The database user needs to be manually deleted on the database server because it isn\'t publicly accessible');`
	`74`	`+ $output->important('The database user needs to be manually deleted on the database server because it isn\'t publicly accessible. You can use the following query to delete it');`
	`75`	`+ $output->writeln(sprintf('DROP USER IF EXISTS %s@\'%%\'', $user['username']));`
`75`	`76`	`}`
`76`	`77`	`}`
`77`	`78`	`}`