moved to 5.1.9 and unable to create tables.

[richard horan]

i built 5.1.9 and created a new directory. i blew away the old data and cluster directories. i did a mysql_install_db and i am unable to create tables.

What am i doing wrong? What do i look for to fix this?


mysql> connect test;
Connection id: 8
Current database: test

mysql> show tables;
Empty set, 1 warning (0.00 sec)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)

mysql> create table junk(i int);
ERROR 1050 (42S01): Table 'junk' already exists
mysql> drop table test.junk;
ERROR 1051 (42S02): Unknown table 'junk'
mysql> drop table junk;
ERROR 1051 (42S02): Unknown table 'junk'
mysql>