fix: add query to grant user access to database server

carlalexander · carlalexander · commit ee1e22b0ff10 · 2022-01-25T17:47:58.000-05:00
diff --git a/src/Command/Database/CreateDatabaseUserCommand.php b/src/Command/Database/CreateDatabaseUserCommand.php
@@ -66,8 +66,9 @@ protected function perform(InputInterface $input, OutputInterface $output)
 
         if (!$databaseServer['publicly_accessible']) {
             $output->newLine();
-            $output->warn('The database user needs to be manually created on the database server because it isn\'t publicly accessible. You can use the following query to create it:');
+            $output->warn('The database user needs to be manually created on the database server because it isn\'t publicly accessible. You can use the following queries to create it and grant it access to the server:');
             $output->writeln(sprintf('CREATE USER %s@\'%%\' IDENTIFIED BY \'%s\'', $user['username'], $user['password']));
+            $output->writeln(sprintf('GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON *.* TO %s@\'%%\'', $user['username']));
         }
     }
 }

Original file line number	Diff line number	Diff line change
`@@ -66,8 +66,9 @@ protected function perform(InputInterface $input, OutputInterface $output)`
`66`	`66`
`67`	`67`	`if (!$databaseServer['publicly_accessible']) {`
`68`	`68`	`$output->newLine();`
`69`		`- $output->warn('The database user needs to be manually created on the database server because it isn\'t publicly accessible. You can use the following query to create it:');`
	`69`	`+ $output->warn('The database user needs to be manually created on the database server because it isn\'t publicly accessible. You can use the following queries to create it and grant it access to the server:');`
`70`	`70`	`$output->writeln(sprintf('CREATE USER %s@\'%%\' IDENTIFIED BY \'%s\'', $user['username'], $user['password']));`
	`71`	`+ $output->writeln(sprintf('GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON . TO %s@\'%%\'', $user['username']));`
`71`	`72`	`}`
`72`	`73`	`}`
`73`	`74`	`}`