Questions tagged [mysql-workbench]
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
513 questions
0
votes
1
answer
105
views
Export Cassandra database to MySQL database
We have an application that we use for Network Monitoring and it uses a Cassandra database. Our Program is ending and the customer wants us to save our trending database for a period of time after the ...
Nik Boatright Boatright Creati
1
vote
1
answer
458
views
The innodb_system data file 'ibdata1' must be writable
This is my first question here
The case is i had a working mysql and xampp 2 year old installation but i reinstalled them to the latest versions , after fixing multiple things i made the two mysql ...
- 11
1
vote
2
answers
969
views
MySQL Workbench error "name is not activatable"
I'm working with Arch Linux using MariaDB through LAMPP, whenever I use MySQL workbench and try to connect to my local database I get the following:
Your connection attempt failed for user 'root' to ...
- 21
0
votes
0
answers
710
views
How to grant SYSTEM_VARIABLES_ADMIN permission to master MySQL user or rds_superuser_role from MySQL Workbench hosted on RDS?
Using MySQL 8.0.39 on an AWS RDS insteance, for troubleshooting purposes we want to be able to Enable/Disable the global general_log setting , being able to turn it on and off easily and quickly from ...
- 9
2
votes
1
answer
164
views
MySQL shows two connections. One does not require a password and is the same database I created with MySQL Workbench
MySQL shows two connections. One does not require a password and is the same database I created with MySQL Workbench.
I have two database connections. One is the database that came with the MySQL ...
- 23
0
votes
0
answers
81
views
Retrieve data from old MySQL installation to a new one
I have a Laravel project. Suddenly, the project was not connecting to the MySQL database. I then realized that the MySQL service was not starting (Windows 11). I tried to start it manually from ...
0
votes
0
answers
174
views
How do I connect MySQL Workbench to SQL Server with System DSN
tl;dr how can one connect Workbench to SQL Server database using Windows Authentication and/or System DSN?
Context: Win11, SQL Server 2022, SQL Server Management Studio 20.2, MySQL 8.0, and MySQL ...
- 148
0
votes
0
answers
393
views
Frequent MySql client error "got an error writing communication packets"
I have several different Linux servers running MySQL 8.0.x instances (ranging from 8.0.23 to 8.0.33).
I occasionally get "error writing communication packets" from clients when connecting to ...
- 101
-1
votes
1
answer
787
views
Why is DATEADD function not working?
I am trying to set a default datetime value for the column "AuctionEndDate" as the datetime one month from now. I'm using sql version 8.0.36, and I wrote several attempts, including:
ALTER ...
0
votes
1
answer
467
views
After Insert and Update Trigger on the same table
I have the following table in MySQL:
CREATE TABLE `userlogtype` (
`UserLogTypeID` int NOT NULL AUTO_INCREMENT,
`UserLogType` varchar(150) DEFAULT NULL,
`InsertUser` varchar(100) DEFAULT NULL,
`...
0
votes
0
answers
140
views
MySQL: Reconnect to Existing Database that I lost access to
Note I am not a programmer by trade. I have the most annoying problem ever while using MySQL 8.0, and all online resources I've seen provide zero solutions.
I have one of those MySQL data directories ...
- 1
0
votes
0
answers
227
views
Unable to connect to AWS mysql RDS instance
I created an AWS mySQL RDS instance (free tier), but i am unable to connect to it from workbench or cli. I have enabled public access to the DB while creation and allowed "All traffic" while ...
- 101
0
votes
1
answer
755
views
Is There a Workaround to Reduce MySQL Table size?
Long story short. I have a MySQL database that has only one table and is around 50GB, while my drive storage is almost full and cannot get reduced.
So the only way is to reduce the size of the 50GB ...
- 1
0
votes
1
answer
110
views
Merging old backup in current database mysql
I have a backup database that contains data up to the specific date 27-11-2023. Currently, I have the latest version of the database with updated records. However, the issue arises when I consider ...
0
votes
1
answer
188
views
MySQL Workbench - How to write a script to delete a connection?
I currently have MySQL Workbench 8.0.33 (and tried .34) and in both cases, I have a database connection that is corrupted. When I attempt to click "delete" on it, MySQL Workbench closes ...
- 101