· 9 years ago · Jul 20, 2017, 04:14 PM
1<?php
2//////////////////////////////////////////////////////////////////////
3echo "Database test!<br />";
4$random = rand(0,100);
5$sqluser = "usr3".$random;
6$password = "pass";
7$db_location = "127.0.0.1";
8$sql_master_u = "root";
9$sql_master_p = "";
10$database = "usr3".$random;
11//////////////////////////////////////////////////////////////////////
12$data = "CREATE TABLE IF NOT EXISTS `admin` (
13 `id` int(10) unsigned NOT NULL auto_increment,
14 `Username` text NOT NULL,
15 `Password` text NOT NULL,
16 `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
17 PRIMARY KEY (`id`),
18 UNIQUE KEY `id_2` (`id`),
19 KEY `id` (`id`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
21//////////////////////////////////////////////////////////////////////
22 mysql_connect($db_location,$sql_master_u,$sql_master_p); //Connect using root values!
23 // Form SQL Queries
24 // makes with no pass
25 //$step1 = "CREATE USER '".$sqluser."'@'%';";
26 //$step2 = "GRANT USAGE ON * . * TO '".$sqluser."'@'%' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;";
27
28
29 // These make with pass
30 $step1 = "CREATE USER '".$sqluser."'@'%' IDENTIFIED BY '".$password."';";
31 $step2 = "GRANT USAGE ON * . * TO '".$sqluser."'@'%' IDENTIFIED BY '".$password."' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;";
32
33 $step3 = "CREATE DATABASE IF NOT EXISTS `".$database."`;";
34 $step4 = "GRANT ALL PRIVILEGES ON `".$database."` . * TO '".$sqluser."'@'%'";
35 mysql_query($step1) or die('<br /><br />Error: '.mysql_error());
36 mysql_query($step2) or die('<br /><br />Error: '.mysql_error());
37 mysql_query($step3) or die('<br /><br />Error: '.mysql_error());
38 mysql_query($step4) or die('<br /><br />Error: '.mysql_error());
39 //////////////////////////////////////////////////////////////////////
40 echo "Username: ".$sqluser."<br />"; // Testing field.
41 echo "Password: ".$password."<br />"; // Testing field.
42 echo "Database: ".$database."<br />"; // Testing field.
43 //////////////////////////////////////////////////////////////////////
44 // The connection stuff below doesnt work as the user but it works as root... why?
45 // answer and i will order you a pizza.
46 //////////////////////////////////////////////////////////////////////
47 mysql_connect($db_location,$sqluser,$password) or die('Could not connect: '.mysql_error());
48 //mysql_connect($db_location, $sql_master_u, $sql_master_p);
49 mysql_select_db($database);
50 // Why does this query not work?!
51 mysql_query($data) or die('<br /><br />Error: '.mysql_error());
52 echo "Done.";
53?>