2,564 questions
0
votes
0
answers
29
views
"Public Key Retrieval is not allowed" on first login
I'm trying to automate a MySQL connection using DBeaver's CLI with the following command:
.\dbeaver.exe -debug -con "driver=mysql|name=TestConn|host=10.18.1.92|port=3306|user=appsupport|password=...
- 13
0
votes
0
answers
32
views
Enum Mapping in Oat++ DTOs Causing Runtime & Compile-Time Errors
I'm using Oat++ with custom enums for serializing/deserializing in DTOs and integrating them with a MySQL connector. I'm facing issues when mapping enums to/from JSON and database fields.
I've tried ...
2
votes
1
answer
59
views
(No such file) error - c++ linking library issue from running executable file
I have been trying to develop a simple c++ program to connect to mysql using the mysql connector/c++ library. I have been running into issues after issues. This is the next hurdle. I am new to CMake &...
1
vote
0
answers
38
views
Spring Boot @Transactional(readOnly=true) not releasing connection with AWS RDS + HikariCP
I am using Spring Boot 3.4.3 with MySQL 8.0 and Hibernate 6.6.8.Final on AWS RDS.
I have implemented CRUD operations using JPA and QueryDSL. Everything is working fine except for one issue.
I added @...
- 11
0
votes
0
answers
21
views
Unable to access mysql under source assistant in ssis project
I newly installed mysql92 server and vs 2022 in my local machine. I tried to access mysql server in VS integration service project, but I can't see Mysql under source assistant. As alternative, I ...
- 1
0
votes
0
answers
25
views
Rails console connects to DB but server does not
I'm running rails 8. The mysql account my app uses had its password changed so I brought down the rails server, updated the credentials file, and restarted the server.
Running rails console in the ...
0
votes
0
answers
47
views
MySQL Connector/C++ Driver Files Compiler Linking Error
I am building a simple c++ program and wanted to integrate MySQL database into it. I downloaded and installed the latest MySQL package(mysql-connector-c++-9.2.0-macos15-arm64.dmg) from the official ...
-1
votes
1
answer
49
views
MySQL connector doesn't take "USE db" in account
This works and returns the correct rows :
cursor.execute('SELECT * FROM my_db.my_table')
This doesn't, no rows are returned :
cursor.execute('USE my_db; SELECT * FROM my_table;', multi=True)
Running ...
- 21
2
votes
2
answers
53
views
Excel VBA ODBC reading field changes it to Null
Summary;
The first time I read a data field, I get 0, every time after, the same record field reads Null. This changes if I debug, step through and watch the values in the locals/watchlist, I get Null ...
- 123
-1
votes
0
answers
22
views
Failed to execute connection with error: Unknown system variable 'transaction_isolation' [duplicate]
Failed to execute connection with error: Unknown system variable 'transaction_isolation'
When am I connect looker studio Myssql connecter to my hostinger server remote Mysql
1
vote
1
answer
54
views
MySQL, go-sql-driver with google auth token
I am looking to connect to a gcp managed db (running on GCP) via a cloud proxy (jump box with local port to connect to managed instance) with go-sql-driver but everything I've tried gcp MySQL instance ...
- 141
0
votes
1
answer
37
views
No suitable driver found using mysql-connector-java 8.0.33
I have a Java program that used to work and then it stopped working.
The error that I am getting is
java.sql.SQLException: No suitable driver found for jdbc:mysql://feldspar:3306/sndm
I looked into ...
- 487
0
votes
1
answer
36
views
RANK() Always Returns 0 in SeaORM Query
I am using SeaORM in a Rust project and trying to retrieve ranked user balances using MySQL’s RANK() OVER (ORDER BY ...). However, the rank field always returns 0 for all rows.
Rust Code:
#[allow(...
- 10.8k
0
votes
0
answers
67
views
Unable to access MySQL server in Python
So I have set-up a mySQL database and am trying to connect to it from Python. Unfortunately the Jupyter kernel keeps dieing if I try to connect. I don't have much to go on given I don't get an error ...
- 35
1
vote
0
answers
44
views
Is there a way to see interpolated mysql query for debugging in Rust?
In rust, I'm using mysql crate to make query with exec_first() function like this :
let query = r"SELECT NAME from MY_TABLE where VALUE=:age";
let datas = params!{"age"=> 2};
...
- 3,771