200 if ($db_type == 'mysql') { |
200 if ($db_type == 'mysql') { |
201 echo _('In MySQL you should now perform the following command:') . "</p>"; |
201 echo _('In MySQL you should now perform the following command:') . "</p>"; |
202 echo "<p><tt>GRANT SELECT, INSERT, UPDATE, DELETE<BR>ON " . $db_name . ".*<br>TO '" . $db_user . "'@'" . $db_host . "'<br>IDENTIFIED BY '" . $db_pass . "';</tt></p>"; |
202 echo "<p><tt>GRANT SELECT, INSERT, UPDATE, DELETE<BR>ON " . $db_name . ".*<br>TO '" . $db_user . "'@'" . $db_host . "'<br>IDENTIFIED BY '" . $db_pass . "';</tt></p>"; |
203 } elseif ($db_type == 'pgsql') { |
203 } elseif ($db_type == 'pgsql') { |
204 echo _('On PgSQL you would use:') . "</p>"; |
204 echo _('On PgSQL you would use:') . "</p>"; |
205 echo "<p><tt>$ createuser " . $db_user . "<br>" . |
205 echo "<p><tt>$ createuser -E -P " . $db_user . "<br>" . |
206 "Shall the new role be a superuser? (y/n) n<br>" . |
206 "Enter password for new role: " . $db_pass . "<br>" . |
|
207 "Enter it again: " . $db_pass . "<br>" . |
|
208 "Shall the new role be a superuser? (y/n) n<br>" . A |
207 "Shall the new user be allowed to create databases? (y/n) n<br>" . |
209 "Shall the new user be allowed to create databases? (y/n) n<br>" . |
208 "Shall the new user be allowed to create more new users? (y/n) n<br>" . |
210 "Shall the new user be allowed to create more new users? (y/n) n<br>" . |
209 "CREATE USER<br>" . |
211 "CREATE USER<br>" . |
210 "$ psql " . $db_name . "<br>" . |
212 "$ psql " . $db_name . "<br>" . |
211 "psql> GRANT SELECT, INSERT, DELETE, UPDATE<br>" . |
213 "psql> GRANT SELECT, INSERT, DELETE, UPDATE<br>" . |