Access Denied when creating database tables with PHP


#1

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);
}

#2

Are using using % as the host?
Please use localhost