DB2 CLI result output

When running command-line queries in MySQL you can optionally use '\G' as a statement terminator, and instead of the result set columns being listed horizontally across the screen, it will list...

Best database independent SQL DDL utility?

I'm working on a project for the .net platform and would like to support multiple database types. I would like to keep the DDL under source control in a generic format then convert it to database...

How can I get a list of user accounts using the command line in MySQL?

I'm using the MySQL command-line utility and can navigate through a database. Now I need to see a list of user accounts. How can I do this? I'm using MySQL version 5.4.1.

Is there a "Northwind" type database available for MySQL?

I need some test data for a MySQL utility that I am creating. Does anybody know where I can find one that has a similiar (if not more) amount of data as Northwind for SQL Server?

Detecting potential SQL injection attacks, as well as other security issues

We all know it is nearly impossible to produce a large website without one or two flaws. As such I've written a small monitor that checks Apache access logs for potential SQL injection attacks...

Mysql service failed to start after I remove all log file

I delete all file in /var/log, however, when I restart mysql service, it failed to start now. help! Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service...

is there a way to list all the reserved words in mysql using the mysql command-line utility

Is there a way to list all the reserved words in MySQL(5.x) using the command-line utility (mysql)?

Visibility of global variables in imported modules

I've run into a bit of a wall importing modules in a Python script. I'll do my best to describe the error, why I run into it, and why I'm tying this particular approach to solve my problem (which...

Filtering fields in RFC_READ_TABLE with SAP JCo

I am attempting to write a simple java utility that extracts data from SAP into a MySQL database, using JCo. I have understood the JCo documentation and tried out the relevant examples mentioned...

Spring data jpa- No bean named 'entityManagerFactory' is defined; Injection of autowired dependencies failed

I'm developing application using spring data jpa,hibernate,mysql,tomcat7,maven and it's create error.I'm trying to figure it out but i failed. error are Cannot resolve reference to bean...

Error using csvsql utility in csvkit python package on Mac Yosemite

I am new to python and mysql. I am trying to use the csvsql utility within the csvkit python library on Mac OS X Yosemite to create a table in my mysql database, and to upload the data. When I try...

Log4j error: NoClassDefFoundError: org/apache/log4j/xml/DOMConfigurator

I am trying to create a web project using spring framework. When trying to run the project, I am getting a HTTP Status 404 error in the browser. Here is the stack trace of the problem from the...

AWS RDS (MySQL) Secure Connection

I have following aws resources an EC2 Instance(running on windows platform) and a AWS RDS MySQL(complied for linux). I want to connect AWS RDS MySQL instance using SSL through MySQL client...

Msg 7391: linked server unable to begin a distributed transaction (both svrs running locally)

I setup a LinkedServer from SqlServer 2014 to MySQL 5.7.3 running on my Win 10 PC. Both select & insert queries work fine alone via openquery, but the insert query won't function in a trigger. ...

Cannot connect to MySQL docker instance via DataGrip application

I have managed to successfully connect to a docker instance running MySQL via the mysql command line utility. However, I am struggling to do so via DataGrip application from JetBrains. My mysql...

NodeJS - Process out of memory for 100+ concurrent connections

I am working on an IoT application where the clients send bio-potential information every 2 seconds to the server. The client sends a CSV file containing 400 rows of data every 2 seconds. I have a...

php-fpm process receiving SIGKILL signal in Kubernetes

I have created the ubuntu docker image with Nginx, PHP and php-fpm configured in it. It is working fine when I am running it on Docker instance. But when I run the same image in kubernetes, the...

Spring boot REST API 404 error

I am trying to create a basic spring boot application (JDK 1.8) with a REST API . The following is my application code package org.demo; import org.springframework.boot.SpringApplication; import...

Hibernate has difficult with create table using MySQL

I'm doing a school project in architecture client-server with JavaFX, Maven, Hibernate etc I have big problem with implementation alone Hibernate (without Spring). Im not sure that is problem...

Find duplicate index in MySQL using query

I know about MySQL utility called mysqlindexcheck. But Can I find duplicate indexes through SQL query. I tried this, but looking for any better idea or improvement SELECT DISTINCT ...

How to import .sql file into MySQL using PowerShell script?

I'm trying to import a dump file (.sql file containing CREATE/DROP/INSERT commands) into a remote MySQL server from a windows environment. I've got this PowerShell script to do the job for me by...

Build dynamic (conditional) WHERE SQL query in Golang

I'm using golang, go_reform, PostgreSQL. What i want to do is a REST search utility, and all went fine until I faced with conditional search query. "Conditional" here means I have 10 columns in a...

How to externally provide mysql host to spring boot while executing JAR

I have a java Spring boot project which uses a MySQL database. I have the following application.properties file to specify the MySQL url, user and...

Checking connection to MySQL (Java)

I'm working on creating my little-utility for MySQL, and I need some help. How I can check connection to MySQL (by login and password), like it was realised in phpMyAdmin, without pointing some...

How to synchronize multi-databases to one central database in remote servers?

I have a project where there are multi-sites (1500 client sites) each contain an Oracle database, and 1 datacenter with MySQL database where all the data from all client sites should reside and...

How repair corrupt xampp 'mysql.user' table?

I used Xampp yesterday to create some simple Web-based utility tool. Today I wanted to continue working on it but xampp control panel gave me some weir errors. This is the MySQL Error...

Error : dbeaver utility 'mysql.exe' not found in client home 'mysql binaries'

when i try to import an SQL file and execute it using dbeaver software it prompt the following error : although i have already installed XAMPP on PC. how to solve this please ?

Docker: Permission denied to local MySQL volume

I'm new with Docker and I don't know Linux well. I'm trying to build my own environment for local development with Docker. I’m using docker-compose utility. I want to store MySQL data in the...

Lumen 8 not using .env.testing

I'm using Lumen 8. and I want to use the configuration inside .env.testing but it always read the configuration inside .env *tests/TestCase.php* <?php use Dotenv\Dotenv; abstract class TestCase...

Failed to convert property value of type 'java.lang.String' to required type in Spring Batch

I am working on a Spring Batch requirement. I am writing a converter class as a utility class in a separate util package in my project. I am reading the CSV file writing to MySQL database. But I...