Solved

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

Posted on 2014-12-11
8
214 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
  • 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

821 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