Page 1 of 1

Strange MySQL 1016 error

Posted: Wed Nov 23, 2005 2:47 pm
by mhouldridge
Hi,

I have installed mysql version 4 on my computer running windows xp pro. I have also installed Navicat and created my database "kp" with tables "users" and "homes"

Now I have installed the same versions (mysql4 and Navicat) on to my server running windows 2003 standard.

Viewing the database tables within my xp computer is fine, however when I try to access them on my servers i get 1016 error.

I have created the administrator user on my server's mysql, exactly the same as the user on my local machine. I have also restarted the server.

Also, I have tried creating the database and then copying the database files across.

One more thing to note is that the database is running using innodb and I have configured my server to use this.


Please help!