?
Solved

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

Posted on 2014-12-11
8
Medium Priority
?
222 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 750 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 750 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

Are You Using the Best Web Development Editor?

The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.

See if your editor made the list.

Question has a verified solution.

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

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

770 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