asked on

Command line mysql user can't drop a table it created

I can (ralph@localhost) create the table, but not drop it. Same w/ XAMPP.
Why?
See attached files.

I discovered this by having same problem w/in XAMPP.

THANKS, I've lost too much time.
Ralph
Screen-Shot-2014-12-11-at-9.25.40-PM.png
Screen-Shot-2014-12-11-at-9.23.49-PM.png
Screen-Shot-2014-12-11-at-9.24.04-PM.png

Ralph

ASKER

Autocorrect changed Global user privs to Global user privy. I didn't do that!

Guy Hengel [angelIII / a3]

creating and dropping are not related as privileges, you can allow creating, while dropping the objects is not granted
you need to get the DROP granted
http://dev.mysql.com/doc/refman/5.0/en/grant.html

Ralph

ASKER

Isn't that what the images show? Or am I missing something?
Thanks!

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ralph

ASKER

Default XAMPP config.
The commands are back to back, and it is creating on my local box.
I guess I can start playing with granting more; maybe in this release there's some not-well documented gotcha of dependencies. ???
I'll find out what will (hopefully) permit it!

SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ralph

ASKER

Back to you on that. I'll start with:
Show all parameters
Look at mysql.conf
Look at ...
I still suspect it's a user/daemon/_mysql permissions problem.
'til I do it then.

Ralph

ASKER

I can't say what resolved it. Maybe it was the reboot.

Separately, which got me going this direction, the .txt file I imported to execute SQL in PHP had two commands in it, so mysql_query() didn't care for that. Worked around it.