I am trying to export my database from MySQL Workbench but I get this during the export progress: Running: mysqldump.exe --defaults-file="c:\users\user\appdata\local\temp\tmp2h91wa.cnf" ...

I am using nodejs, express framework and mysql for my database. I would like to know how can I replicate this mongoose code using mysql. I cannot find a way to write my sql schema in a nodejs file....

I am using MySQL Workbench 5.2, the newest version as far as I know, but I simply cannot change the font. It is very inconvenient, because the default font is very small and harsh on the eyes. The ...

I have a schema designed in MySQL Workbench. I put descriptions in for the tables, and comments for columns and views. I created a diagram, and I'd like to see the comments and descriptions in th...

I've googled this but all the examples are on an old excel. My current excel does not have the option of MySQL on the Data tab. i tried importing through Other Source, SQL Server but it doesn't con...

I open workbench and connect to a local database on XAMPP and when open the connection the schema show the error message: "tables could not be fetched"

Does anyone know how to pull a database Scheme Diff for two databases using MySQL Workbench. v5.2 states it has this feature, but I can't seem to find it. I must use MySQL Workbench.

Trying to get a SQL query where you define the value once and it searches multiple columns. I got this working for the equal operator, but I need this for a LIKE operator as well. This is were the ...

I run MySQL 5.6 since month and everything went well. Also the MySQL Workbench 6. I receive two errors if I would like to see the "Server Status". 1st error: Could not acquire management access ...

How do I show a message from a stored procedure? What is the right syntax to display a message saying whether or not rows exist? In SQL Server it's PRINT to show a message bat in WORKBENCH... CR...

I am trying to install mysql workbench. I am getting below error. It seems that it looks for mysql in some default directory. I have all the required things installed, but not where mysqlworkbench ...

after upgrading my MacBook to macOS Sonoma 14.0 I'm unable to work consecutively on MySql WorkBench. it keeps crashing after the second or third execution of a query or stored procedure. has ...

I have already installed Visual Studio 2015 x64 Redistributable but still the server failed to install. What could be the reason?

I have a line of code for SQL server which takes a date listed as "YYYYMMDD" where the DD is 00 and converts the 00 to 01 so that it works with datetime. I would like to be able to use MySQL for it...

I'm using MySQL Workbench CE 5.2.30 CE / Rev 6790 . When execute the following statement: SELECT OLD_PASSWORD("test") I only get back a nice BLOB icon, I need to left-click to select the cell, r...

I inserted data to mysql table 'table1' using java.But in the table in the workbench doesn't updated.When I retrive that table using java,inserted data using java will be shown.How to refresh my 't...

I was trying to import csv data file using command prompt in MySQL Workbench (mysql Ver 8.0.30 for Win64 on x86_64 (MySQL Community Server - GPL)). Using following steps: mysql> load data local ...

I am trying to migrate a 1.4 TB DB on SQL server to MySQL. I am using MySQL workbench to do the migration SQL server is 2022 dev edition. MySQL version is v 8 It is throwing following errors :- Co...

I have the latest version of MySQL Workbench. I have MySQL in a virtual Ubuntu machine and am trying to connect via SSH. MySQL Workbench keeps crashing without showing any warning or error.

I am connecting MySQL - 8.0 with MySQL Workbench and getting the below error: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_pas...

When trying Edit Table Data in MySQL Workbench 5.2.37, its in read only mode. It is editable only if the table has a primary key. Is there any fix to deal with table without primary key? As one of ...

EDIT for present day readers This was a bug in an old version of DBeaver that was subsequently fixed. I am getting an 'access denied' error trying to connect to a Google Cloud SQL MySQL instance w...

I installed a server using Laravel Forge. Authentication is via SSH keys which I provided. I can connect to the server via putty with my private key. Also am able to connect to the mysql using the...

I'm creating the simple api project in nodejs. For that I have installed mySql workbench with version 8.0.11. I have created config file, dbConnection.js file and in the dbconnection.js file I have...

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles acros...