I am trying to create a user who will be able to manage all databases without the right to  CREATE and DROP databases.I have been using the following link :http://dev.mysql.com/doc/refman/5.0/en/privileges-provided.html#priv_createGRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON *.* TO 'mysql'@'192.168.1.0/255.255.255.0' IDENTIFIED BY PASSWORD 'toto'I would like to add CREATE in order to allow the user to create a table, but If I do this the user will be able to create a database too.Is it possible to provide CREATE table without CREATE database privilege ?
Mysql user privileges : Only CREATE table
mysql