A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
0
votes
1answer
14 views
Default user Accounts in Mysql
I'm new to MySQL and installed MySQL in Ubuntu 16.04. At the time of installation I have given password for root.
In the terminal I can access only root user and created user only.
bharath@bharath-...
0
votes
1answer
35 views
Syntax error - CREATE DATABASE
I'm new with MySQL Workbench and with MySQL itself, but my teacher want me to build the database in SQL, not on Access. I learned a bit of MySQL,started and this is my code for the moment:
CREATE ...
0
votes
1answer
45 views
Error code 1290 and inability to import data on table
I am running a 5.7.16 version of MySQL on my Windows 8 operating system. I am facing troubles when trying to load datas into a table. I tried with the script
LOAD DATA INFILE 'C:\Users\xxx\Dropbox\...
1
vote
2answers
38 views
Import data into MySQL using Talend Open Studio
I have been trying to import CSV data about 60Mb, but contains about 400,000 rows, which should not be too much.
I used these ways to import the data:
1) MySQL Workbench - it took about 2hours!!!
2) ...
0
votes
0answers
14 views
insert error: (1064 … from python script importing into sqll workbench
This is the piece of code that is getting the error. I'm trying to parse through a table and check for Primary keys using the code below. If the the key exists, it won't insert the data etc.
...
0
votes
1answer
25 views
“Incorrect string value” while migrating from MSSQL to MySQL with Workbench
I got the task to migrate our MSSQL database into a MySQL database.
Therefore I am using the recent version of MySQL Workbench and FreeTDS Driver.
During the migration I always get errors like this:
...
1
vote
2answers
120 views
ERROR 1067 (42000) at line 7: Invalid default value for 'LAST_UPDATED'
Running MySQL 5.5, got the error above when I tried to import a .sql file
I've checked the SQL_MODE of my server and nothing similar to 'NO_ZERO_DATE' is found
As well, I've took out the text of '...
0
votes
0answers
29 views
Can Windows authentication be used with MySQL Workbench-generated migration scripts?
Because of an apparent instability in MySQL Workbench (which I asked about here), I'm trying to work with a migration script generated by MySQL Workbench which, as I understand it, offloads most of ...
0
votes
0answers
47 views
MySQL Workbench helper process exiting with error status -1073740940
I'm in the process of migrating an SQL Server database stored in SQL Server 2014 to MySQL using MySQL Workbench's migration tool.
I've successfully imported my source database into SQL Server and I'...
1
vote
0answers
20 views
Dynamic SQL Stored Procedure called by a Function
I want to be able to dynamically call a function that contains a select statement whose table changes depending on the function parameters. I know this is not possible to do within a function, but I ...
0
votes
1answer
25 views
MYSQL workbench & other IDEs not working on fresh OS after reinstall?
I've recently had to format my computer and re-install my Win7 OS. Then I reinstalled the MySql workbench I was using last time. However, each time I open it and create a schema, the entire workbench ...
0
votes
1answer
22 views
Change table schema in the workbench
I have three different schemas, ended up creating all the tables in one, but now I want to put them in their correct schemas.
How can I do this without using scripts?
the version of Workbench that ...
0
votes
0answers
6 views
Can't retrieve mysql table using mysqlToolbox when I grab all rows
here is the create table syntax:
CREATE TABLE `transactions` (
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`trxResult` varchar(45) NOT NULL,
`email` varchar(254) NOT NULL,
`...
3
votes
2answers
112 views
Delete Slow Query Log File
I was logging slow queries of my system. Now I have few queries to be optimized and reset the global slow_query_log variable to 0. Now I want to delete slow query log file mysqld-slow.log. can anyone ...
0
votes
1answer
38 views
How to export table definitions and data in mysql workbench
I am using mysql workbench 6.3 and I can´t find a way to generate a sql file with one table definition and data.
I could find where to export data or table definition but not both.
0
votes
1answer
95 views
How to search in blob binary wise, and how to export data binary wise
I've a table with a blob field for each row.
The blob contains binary data, which can be represented as bytes or text ( using mysql workbench - open value in viewer)
1.Does anybody know how can I ...
-4
votes
1answer
80 views
I need to change the format of 'date' from yyyy-dd-mm to mm-dd-yyyy [closed]
My dilema,
I was requested to populate a table of sample data and I completed the command to add a date.
I entered '07-07-2016' as sample data. When running a query the "date_ordered" field came ...
0
votes
1answer
23 views
MySQL Workbench Synchronization False Positives
I have synchronized a table between a model and a live server database in Workbench, but every time I rerun the "Synchronize With Any Source..." wizard, Workbench detects (falsely) that there is a ...
2
votes
1answer
122 views
How to recover a lost password in MySQL 5.7.11? (for Windows)
I am running MySQL 5.7.11 on Windows 10
I am unable to login to root through the command line client since I lost my password.
How do I change/reset the old password?
Please help, and thanks in ...
1
vote
1answer
60 views
Fail to connect from MySQL Workbench to remote server
After trying many different suggestions as found in the net, I'm still unable to establish a connection from the Workbench application to the server. Here is a brief list of things I tried:
1) ...
2
votes
2answers
28 views
Out of range errors while with insert statements
I'm having an issue regarding every third insert line of the database I'm trying to create.
Some background, I have a huge .JSON file and used software (sqlizer) to turn it into input statements, ...
1
vote
1answer
155 views
How to restore database with ib_log0, ib_log1 and ibdata1 files in MySQL
We have a Mysql5.5 running on Windows server 2008 from past 4 years.
Recently we have moved ib* files to new locations because of space constraint in c drive.
When we started the Mysql it created ...
0
votes
1answer
35 views
Migration MySQL to Cloud Environment replication
I'm having 5 MySQL database server , these 5 server are used for e-business web-server. Now I Would like to move the MySQL database to cloud environment for database continuous running. Recently we ...
1
vote
1answer
64 views
mysqldbcompare giving Compare table checksum FAIL error
Running mysqldbcompare on two test databases on same server. There is no data discrepancy in any table but showing following message which I'm not able to understand. Any help is appreciated.
TABLE ...
1
vote
2answers
332 views
UTF8 Trouble while migrating from MSSQL to MySQL with MySQL Workbench
I am tasked with migrating part of our database from an on-site MSSQL server to an Amazon RDS MySQL. This will be my first attempt with a database migration, so I am doing a dry run from our MSSQL ...
0
votes
1answer
22 views
Grand read privilege to the user but is not allowed to grant the same privilege to another user?
i am a noob and this is how far i got so far, thanks and also how would you do it if you want to allow user to grant the same privilege to another user.
GRANT SELECT ON DATABASE_NAME.* TO USER;
2
votes
2answers
547 views
MySQL Front - Workbench
We have MySQL Front installed in our server, I can connect to it with no problems, there is a db with tables, everything fine.
Now I installed MySQL workbench (client) in the same server, but can ...
1
vote
0answers
228 views
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xx' (10060)
I'm trying to connect my local MySQL workbench to a 2nd generation MySQL instance on Google SQL platform using the following command on my windows laptop.
mysql --host=130.xxx.xx.xx --port=3306 --...
3
votes
1answer
50 views
Online text based game design - Am I linking the databases correctly?
I'm trying to recreate an old game that I used to play that went offline quite some time ago. I'm doing this as a hobby project for myself with the hope that maybe a few hundred people might enjoy it ...
0
votes
2answers
48 views
How to Add AFTER Delete Trigger in My case?
I am Making a Database Management System of Hospital in MySQL WorkBench, and i Want to Make a After Delete Trigger in my case. The scenario is i have two Tables
1) The Patients which are currently ...
0
votes
1answer
284 views
Export .MWB to working .SQL file using command line
We recently installed a server dedicated to unit tests, which deploys
updates automatically via Jenkins when commits are done, and sends
mails when a regression is noticed
> This requires our ...
1
vote
1answer
230 views
Insert all dates from a month into a table
I'm confused. How to get all dates from a month and insert them into a table in a database?
I want to do this with a trigger so when I make a period, ex April 01-04-2016 / 30-04-2016, then in table ...
0
votes
1answer
41 views
Closed queries re-open when connecting to DB using MySQL Workbench
Using MySQL Workbench latest version (6.3) I've set up an Amazon EC2 connection successfully. Every time I open the connection, I've noticed all queries I did before are being opened, even if I closed ...
0
votes
0answers
35 views
Mysql workbench dies on a certain query
I'm running MySQL workbench 6.3 CE connecting to Mysql 5.7.11 running ubuntu via an SSH tunnel.
When I execute the following queries, the first 3 complete easily, while the last one spins forever.
...
0
votes
3answers
79 views
How to select mutiple values with like clause
SELECT *
from table
WHERE column LIKE "AAA%"
OR column LIKE "BBB%"
OR column LIKE "CCC%"
I have more than 10 values to select, so it is not appropriate to write like the above example. Is ...
0
votes
1answer
38 views
Can I reference a specific column in a remote table (MySQL)?
I have two databases (MySQL) on two different servers, and one table references a table in the other. However, I am unable to point the reference to a specific column in the remote table for some ...
1
vote
1answer
178 views
MySQL Workbench fails to store password in vault
I am trying to access my SQL server through MySQL Workbench. So I click the + sign to create a new connection.
At this point I choose a connection name and enter the hostname, username, and port. ...
0
votes
1answer
66 views
Possible hidden limit reached in MySQL instance
I'm developing a node.js/sails.js application and host my MySQL database on a Google compute engine instance.
During load testing it hits some limit at 1300 RPS. The instances hosting the application ...
0
votes
0answers
23 views
MySQL server v5.7 error 2013 and 2006 when system date is changed
I have a problem with my MySQL server v5.7 when I would perform a query and the system date is the current date everything works. But when I change the system date and perform the query again in MySQL ...
0
votes
0answers
314 views
Visual Explain Not working in MySQL Workbench
Is there some trick to getting the Visual Explain feature to work in MySQL Workbench?
I am running version 6.3.6 on Windows 7.
I've tried simple queries with just one join. I've tried it with complex ...
0
votes
1answer
41 views
Why does this MySQL 5.6 stored procedure not compile with MySQL Workbench?
Why doesn't this MySQL 5.6 stored procedure compile with MySQL Workbench?
CREATE PROCEDURE spDataLocationSetActive
(
IN driveLetter varchar(1),
IN active ...
0
votes
1answer
182 views
Synchronize MySQL database from remote MySQL database
The documentation mentions a sync function, but that function is not available from the Database menu as shown in the screenshots there. Is this functionality available elsewhere? Using reverse ...
0
votes
2answers
248 views
MySQL Workbench doesn't automatically refresh the tables content
I have a database running on localhost and the content of this DB is updated by an app (using Hibernate, for the record). In this order:
In Workbench I run a SELECT * to check to DB content
I add a ...
1
vote
1answer
31 views
MySQL getting errno: 150 on table creation from Workbench
I'm inexperienced with MySQL and I am trying to build a few tables and getting errno 150 which I believe could be to do with Foreign Keys. Here is my SQL as generated by Workbench. Thanks in advance ...
0
votes
2answers
82 views
How to observe output from query in Workbench 6.3?
I am just starting to use MySQL Workbench 6.3, and I want to just run simple queries. I've created a table with the appropriate schema and everything, but I can't seem to observe the output from my ...
1
vote
0answers
82 views
Database design in MySQL workbench
After doing some change As Mr Vérace told me here in this question, by changing the id names of each table into table_name_id and using the singular notation, I still need your opinion about this ...
2
votes
1answer
75 views
How to model the relationship between these three tables
This is my first database, it is for a nutritional info meal tracker program. I have created a model in mySql work bench but I'm not sure if I have the relationships right. See image below..
My ...
0
votes
1answer
54 views
Execution plan not understanding correctly
I am running a query:
SELECT * FROM message where fr_user = 1 ORDER BY created DESC LIMIT 10;
Without the LIMIT there would be 170 rows returned where fr_user = 1;
I am now trying to understand how ...
0
votes
0answers
36 views
mysqlworkbench nasty result grid with text columns
On MySQL Workbench 6.3, when you query a table with text columns that have carrier return \n in it, the Result Grid expands record's height accordingly.
In the image, I've reduced the height of the ...
0
votes
1answer
106 views
MySQL workbench alter table is incomplete
I have just upgraded MySQL 5.6 to 5.7 and workbench from 6.2 to 6.3.6 to have the latest and do some modelling. The upgrade went fine and the app runs perfectly but something is different and I can't ...
