Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. $sql = "CREATE USER '$mysqluser'@'%' IDENTIFIED BY '$mysqlpassword1';";
  2. $sql.= "GRANT SELECT, INSERT, ALTER, UPDATE, DROP, DELETE, CREATE ON $databasename.* TO '$mysqluser'@'%' IDENTIFIED BY '$mysqlpassword1';";
  3. $sql.= "INSERT INTO pma__users (username, usergroup) VALUES ('$mysqluser', 'General User');";
  4. $sql.= "CREATE DATABASE $databasename";
  5. if (mysqli_multi_query($conn,$sql)) {
  6. echo 'Success.';
  7. } else {
  8. echo 'Error.';
  9. }
  10.  
  11. $conn->select_db("StartableHosting");
  12. $sql2= "INSERT INTO mysql_accounts (username, cust_id) VALUES ('$username', '" . $_SESSION['id'] . "')";
  13.  
  14. if ($conn->query($sql2)){
  15. echo 'Success.';
  16. } else {
  17. echo 'Error.';
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement