All Questions
Tagged with mysql-workbench mysql-connector
46 questions
0
votes
0
answers
24
views
Workbench not opening on the Desktop
I have installed Mysql on my system using the normal documentation procedures and instructions. I have also downloaded the Mysql workbench also by following instruction from Msql documentation website....
- 1
0
votes
0
answers
459
views
Unable to load authentication plugin with MySQL Authentication Plugin
I'm encountering an error in my MySQL application, and I'm seeking assistance in resolving it. I'm using MySQL Connector/J to connect to a MySQL database, and I keep encountering the following error ...
- 1
0
votes
0
answers
1k
views
MySQL Workbench UBUNTU 22.04.3 LTS - Cannot Connect to Database Server "User interaction failed"
After clicking on MySQL Connection I'm getting the message:
Cannot Connect to Database Server "User interaction failed"
I tried to reset root password via ALTER USER but same message "...
0
votes
0
answers
69
views
MySQL - Query failed from workbench /application with Error code: 2013 lost connection to MySQL server during query
We have query with large amount of data.
We are running query from workbench or application (java application) but not showing result.
error:
Error code:2013 lost connection to MySQL server during ...
- 1
0
votes
0
answers
68
views
My sql installer only downloading connectors
when I am trying to download mysql in my windows it is only showing connectors being downloaded.
whatever setup type I choose it only downloads connectors. what should i do?
here is srnshot of ...
- 1
0
votes
0
answers
187
views
Unable to connect mysql with a new connection on mac
The mac os is ventura 13.3
I installed mysql with brew and make sure that it run on port 3306. In system settings, the mysql(v8.0.33) is confirmed to be running.
The sequence of installation is first ...
- 532
0
votes
3
answers
101
views
Error: Not all parameters were used in the SQL statement (Python, MySQL)
I get an error in the following Python code:
My Mini Project
def dbconnect():
try:
db=mysql.connector.connect(host='localhost',user='SYSTEM', password='123456', database='billing_system')
...
-2
votes
1
answer
607
views
Retrieve the order id and the number of days between order date and payment date for all orders [closed]
Ans...,
select orderid as "ORDERID", abs(pymtdate-Orderdate) as "NOOFDAYS"
from orders
0
votes
0
answers
428
views
Vite react not sending inputs to backend express
Please I have a problem am using vite for react project and wen I try to submit my signup form it show code: er_empty_query with status number 200 any help please
Am trying to create a signup form but ...
- 11
0
votes
0
answers
52
views
I am unable to connect visual basic to MYSQL [duplicate]
Hi I am trying to connect visual basic to MYSQL but I am having two errors. One is when clicking on the drop-down list of databases it doesn't show any database; instead it displays an error saying ...
- 19
0
votes
0
answers
51
views
How to access the muliple database in a same time with JDBC not in JPA
I just created a sample project in Spring Boot using CRUD operation & JDBC. Now, I want to get the data from two different databases at the same time
I need to get two table values for the use of ...
0
votes
0
answers
51
views
Importing CSV files always fail
My problem is failing to import any csv file from my laptop
I always get errors ( 2068, 1083,or 3948 )
I have tried Changing in my.ini text file ,but editing is prevented
I wrote this code
SHOW ...
- 5
0
votes
0
answers
30
views
how to use both where clause and group_concat in single table in mysql?
select `Part Name` ,`Current Status` as `Current Status`,
group_concat(`Inward Qty`) as `Inward Qty` from production
where `Current Status` = 'Active' group by `Manufacturer Part Number`;
I have ...
0
votes
0
answers
568
views
The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
I got the error ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement.
How to disable this on a MacOS software.
I tired all the steps ...
- 3
0
votes
1
answer
59
views
How to optimise mysql database
I have a problem concerning database created in MySQL Workbench.
My data base has 2 tables:
data and experiments created as:
create table data(
preprocessed_datasetID int NOT NULL PRIMARY KEY ...
- 11