On Thursday 15 April 2004 07:29, Jeffrey L. Taylor typed: [SNIP]
As you surmised, there is a permission problem. MySQL permissions are finer grained than Linux permissions. You need to grant the drop permission to that user, something like:
grant drop on database.* to username;
Substitute the real database and username. I haven't tested this and am not a MySQL expert. I am not sure whether the above adds the drop permission or sets the permission to only drop. Hack away at it or find someone who really knows what they are doing ;)
Yes, it helps. I have not reached the place where I can actually see the data
in a database; but if you log in as root, and use database mysql, there area
five tables in it that have to do with permissions; and the one called "user"
has a row that is called "Grant_priv", but I don't know how to see what's in
it! I looked ahead in the Tutorial, and was sufficiently confused enough to
decide that I'll be getting to it soon enough if I just go through everything
in order!