Solved

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

Posted on 2014-12-11
8
217 Views
Last Modified: 2014-12-15
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
0
Comment
Question by:Ralph
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
8 Comments
 

Author Comment

by:Ralph
ID: 40495515
Autocorrect changed Global user privs to Global user privy.  I didn't do that!
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40495526
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
0
 

Author Comment

by:Ralph
ID: 40495530
Isn't that what the images show?  Or am I missing something?
Thanks!
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 40495538
unless you are on the wrong database/server, I cannot explain this
maybe there is a "deny" on a more general level indirectly attached to the user ... like to DENY DROP TO %.localhost for example...
0
 

Author Comment

by:Ralph
ID: 40495544
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!
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 250 total points
ID: 40495614
I have a pretty stock install of XAMPP and I don't have any problem with the 'drop' command.  Check your settings I guess, something isn't as you think it is.
0
 

Author Comment

by:Ralph
ID: 40495938
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.
0
 

Author Comment

by:Ralph
ID: 40501786
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.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question