Questions tagged [mysql]
MySQL is a free, open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. Those are different DBs that all use their own dialects of SQL to manage the data. Always specify the exact version of the server in the question. Note that configuration/setup-related questions are off-topic on stackoverflow.
mysql
191,931
questions with no upvoted or accepted answers
37
votes
1
answer
9k
views
MySQL Entity Framework 6: Database First. How to create classes?
Until now I've been using EF6 with Visual Studio, mostly code first, rarely database first.
To import some test data, someone gave me the connection to a database in MySQL. In MySql Workbench I can ...
20
votes
3
answers
1k
views
Access to MySQL with R using a pre 4.1.1 authentication protocol
I need to access to a MySQL remote server, and I want to do this with the R software.
I set up the connection parameter but I can't access. I use this code:
drv <- dbDriver("MySQL")
library(...
18
votes
1
answer
596
views
_mysql_init not found when using DataMapper
I have a simple MySQL table:
% mysql -u rampion dev -e 'describe person'
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra ...
17
votes
1
answer
15k
views
Upgrading to MYSQL 8 - MAMP
I have installed MAMP on my MAC machine and I am trying to upgrade it to use MySQL 8. However, I am not having any luck. I have tried following script but database migration fails.
Also, sequelPro ...
17
votes
1
answer
6k
views
Airflow tasks getting killed with "Scheduler heartbeat got an exception" error
I have a dag which runs 4 tasks which are all bash operators. Recently i moved to airflow version 1.10.2. I am seeing the below error frequently:
ERROR - Scheduler heartbeat got an exception: (MySQLdb....
17
votes
1
answer
2k
views
Sonarqube 4.5.4 : MySQL deadlock
I am using sonarqube 4.5.4 with mysql database.
I got this exception when running analysis on my projects :
INFO o.d.m.sonar.runner.RunSonarVisitor - ### Error updating database. Cause: com.mysql....
17
votes
1
answer
2k
views
AWS RDS Mysql kill transaction by ID (without thread_id)
I'm currently having an issue with some long running transactions that are holding locks to a single row in a table that I'm being unable to kill.
Innodb_trx holds the following information - special ...
16
votes
0
answers
1k
views
Use c3p0 with JBOSS AS 7.1.1
I read in c3p0´s manual link that it is possible to use c3p0 library inside JBOSS as an MBean.
Once configured correctly, I would like to reference the new C3P0PooledDataSource in my Java WAR through ...
15
votes
1
answer
3k
views
How to resolve writing configuration error while installing mysql?
I am new to MySQL. I downloaded the MySQL windows installer and selected I guess everything I thought I would need for x64 and x86 products especially utilities, workbench and MySQL Server for MYSQL 8....
15
votes
3
answers
16k
views
Find the query from query_id in mysql
Can I find the exact query from mysql query id?
This is a part of "SHOW ENGINE INNODB STATUS" in MySQL:
MySQL thread id 1106, query id 1360 localhost 127.0.0.1 test2
---TRANSACTION 0 19491, not ...
14
votes
5
answers
10k
views
select "all columns" with "group by" in hibernate criteria queries
I want to write a criteria query using "group by" and want to return all the columns.
Plane sql is like this:
select * from Tab group by client_name order by creation_time;
I understand that it ...
13
votes
2
answers
15k
views
c3p0 getConnection() throws exception: A ResourcePool could not acquire a resource from its primary factory or source
We have a [Hibernate + c3p0 + MySQL] config for our project. We are hitting the following exception:
com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a ...
13
votes
2
answers
1k
views
Issues about C# connecting to EC2
I am currently using Amazon EC2 (AMI linux) + MySQL, and now I am working on C# stuff.
I wrote code like this:
MySqlConnection DBConn = new MySqlConnection();
DBConn.ConnectionString ...
12
votes
0
answers
4k
views
Deploying bitnami/mysql helm chart with an existing Persistence Volume Claim
I'm trying to deploy bitnami/mysql chart inside my minikube.
I'm using Kubernetes v1.19, Minikube v1.17.1 and Helm 3
I've created a PVC and PV as follow:
kind: PersistentVolumeClaim
apiVersion: v1
...
12
votes
0
answers
1k
views
AWS Glue disable sslmode for target connections
Am quite new to AWS Glue; we are building an ETL process that pulls data from an external source on a MySQL database into Redshift.
After adding the connections it and testing them it would connect ...