mysql grant issues
 

hello everybody,

mysql issue on linux redhat 9..---->cant create tables in mysql

as a root user i created a database and granted a user access to it to create tables..
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON test2db.* TO test2db@localhost IDENTIFIED BY 'test2dbpwd2';
Query OK, 0 rows affected (0.08 sec)

then i logged in as the user "test2db"
mysql> use test2db
Database changed

mysql> status
--------------
mysql Ver 11.18 Distrib 3.23.54, for redhat-linux-gnu (i386)

Connection id: 8
Current database: test2db
Current user: test2db@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.54

** tried creating a table using the following command but for some reason its not creating the table....
mysql> create table test_table (f_name varchar(20), l_name varchar(20), age int);
ERROR 1044: Access denied for user: 'test2db@localhost' to database 'test2db'
mysql>
am i missing something here?
i should also add that, i'm able to create the tables as a root user...

Note the list of privileges you granted: Select, Insert, Update and Delete. Note that none of these are CREATE. So basically, the database is behaving perfectly. You just need to grant yourself a few more permissions.