I'm having a little trouble with granting the correct privilege to the user with one database instead of all databases. When I do this with all databases, it work great.. --snip-- //Issued SQL Command... GRANT ALL ON *.* TO 'Username'@'localhost.domain.com' <mailto:'Username'@'localhost.domain.com'> IDENTIFIED BY 'Password'
//Correct Data in user table in mysql database.. +-----------+---------+------------------+-------------+-------------+-- -----------+-------------+-------------+-----------+-------------+------ ---------+--------------+-----------+------------+-----------------+---- --------+------------+--------------+------------+---------------------- -+------------------+--------------+-----------------+------------------ +----------+------------+-------------+--------------+---------------+-- -----------+-----------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | +-----------+---------+------------------+-------------+-------------+-- -----------+-------------+-------------+-----------+-------------+------ ---------+--------------+-----------+------------+-----------------+---- --------+------------+--------------+------------+---------------------- -+------------------+--------------+-----------------+------------------ +----------+------------+-------------+--------------+---------------+-- -----------+-----------------+ | localhost | Username | 14617e5f1090a4a9 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | +-----------+---------+------------------+-------------+-------------+-- -----------+-------------+-------------+-----------+-------------+------ ---------+--------------+-----------+------------+-----------------+---- --------+------------+--------------+------------+---------------------- -+------------------+--------------+-----------------+------------------ +----------+------------+-------------+--------------+---------------+-- -----------+-----------------+ --snip-- I don't want to this user to have access to most databases, just only one database. When I do this, it doesn't grant the priviledges the same way... --snip-- //Issued SQL Request GRANT ALL ON DATABASE_NAME.* TO 'Username'@'localhost.domain.com' <mailto:'Username'@'localhost.domain.com'> IDENTIFIED BY 'Password' //Incorrect Data in user table in mysql database.. | localhost | Username | 14617e5f1090a4a9 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | --snip-- What do I need to do to make those 'Select', 'Update', 'Delete', 'Alter', etc.. to be "Y" by issuing that SQL Request from above??? What did I do wrong?? Thanks, Scott
