I’m trying to create tables with a PHP script. I know that I have successfully connected to my database as I’ve made other scripts that work just fine. However, when I try to create a table with one of my scripts I get this error:
Error: Access denied for user ‘id3595091_accounts’@’%’ to database ‘id3595091_games’
Is it against the rules to create tables for your databases through PHP?
Here’s the code I’m using to create the tables (or well, attempting to create the tables):
$query = "CREATE TABLE game$currentGameIndex (id bigint(20), username varchar(256));";
if(!mysqli_query($gamesConn, $query)) {
echo "Error: " . mysqli_error($gamesConn);
}