On Thu, 2004-04-15 at 10:47, Mark Seven Smith wrote:
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!
So that's what I am going to do. Thanks! --Mark VII
Webmin can be your friend when it comes to MySQL. -- Ken Schneider unix user since 1989 linux user since 1994 SuSE user since 1998 (5.2)