Principal Software Engineer/Architect, motorcyclist, drummer, and artist
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.
If you would like to, in a shell script, dynamically generate SQL queries for MySQL and save the output of those queries to a variable that you can then use in the script, here is an example:
#!/bin/bash
for i in `cat tables_list.txt`
do
# Build the query
QUERY="SELECT count(*) FROM ${i}"
# Run the query from the command-line and save the
# output into the $ROW_COUNT variable
ROW_COUNT=$(echo $QUERY | mysql -u${USER_NAME} -p${PASSWORD} -h ${HOST} -P ${PORT} --skip-column-names ${DBASE})
So I’m dumping a database on a remote server to pull down to my local box to do some development. When loading the mysqldump file I encountered the error:
ERROR 1005 (HY000) at line 8680: Can't create table 'database.table' (errno: 150)After doing some searching online it seems that is one of the notoriously cryptic MySQL error messages that is woefully overloaded.
I did manage to fix the error (which ended up being a foreign key reference from another table → Continue reading “Figuring out MySQL ERROR 1005 (HY000) Can’t create table (errno: 150)”
Following are a couple of ways to execute SQL on a remote MySQL server via the shell.
Executing SQL directly from the command line:
$ mysql -u uid -p -h remote.host database -e ‘SQL query here;’
Executing SQL from a file on the local host on the remote server:
$ mysql -u uid -p -h remote.host database < file.sql
You can also connect to the remote mysql server and from the command line execute SQL from files on the local → Continue reading “Executing MySQL Queries and Commands from the Command Line to a Remote Server”
Following is how to generate dynamic SQL in a shell script and then execute those queries.
Let’s say, for instance, that you have a list of tables that you want to flush regularly during development and don’t want to type in the SQL queries each time. Moreover, you just want to maintain a list of the table names and add and remove from it when necessary and have your script dynamically generate and execute the delete statements.
For the purposes → Continue reading “Executing Dynamically Generated SQL Queries from a Shell Script”