(First_Name, Last_Name, Middle_Initial,
Address, City, State, Zip, Email, Age,
Gender, Race, Eye_Color,
Hair_Color, Fav_Activity, Fav_Movie,
Occupation, Smoker)
VALUES('$FirstName', '$LastName', '$Middle',
'$Address','$City', '$State', '$Zip', '$Email', $Age,
'$Gender','$Race', '$EyeColor', '$HairColor',
'$FavActivity',
'$FavMovie', '$Occupation', '$Smoker')");
Create the user in the MySQL database
$UserName = $FirstName."_".$LastName."@%";
$dbh->do("GRANT INSERT, DELETE, SELECT ON Meet_A_Geek.Ads
TO $UserName IDENTIFIED BY '$Email'");
$dbh->do("GRANT INSERT ON Meet_A_Geek.Orders
TO $UserName IDENTIFIED BY '$Email'");
$dbi->do("GRANT
UPDATE (Fav_Movie, Fav_Activity, Occupation, Smoker)
ON Meet_A_Geek.Customers
TO $UserName IDENTIFIED BY '$Email'");
$dbi->do("GRANT SELECT ON Meet_A_Geek.Customers
TO $UserName IDENTIFIED BY '$Email'");
$dbi->do("FLUSH PRIVILEGES");