This indicates that the user already exists, or did exist but that all of the data for that user has not been deleted.
As the mysql root user:
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'hostname';
DROP USER 'user'@'hostname'
Then re-try creating the user.→ Continue reading “Solution for MySQL ERROR 1396 (HY000): Operation CREATE USER failed for”
So, I fire up SQL Developer to run some queries against a QC server and for some reason, I am no longer able to use the backspace, delete, or return keys to edit .sql files opened in the program.
I tried opening a new .sql file, and restarting SQL Developer. I then tried restarting Windows. None of those worked.
After a bit of searching I found a forum posting that indicated by going to Tools/Preferences/Accelerators and clicking the “Load Preset…” → Continue reading “Backspace, Delete, and/or Return Key Stops Working in Oracle SQL Developer”
I was trying to run Oracle SQL Developer for the first time on a new machine. When firing it up, it presented me with a dialog box asking me to “Enter the full pathname for the java.exe file”.
OK, no problem. So I find the path to the java.exe binary that was just installed with the SDK. Hit submit . . . and nothing happens. It blanks out the text field and the dialog box stares back at me.
I → Continue reading “Unable to Set the Path To java.exe When Running Oracle SQL Developer Under Windows 7”