Questions tagged [mysql-workbench]

A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.

Filter by
Sorted by
Tagged with
12
votes
1answer
8k views

MySQL Workbench Database Sizes

I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using. Does anyone know of an easy way to figure this out? If nothing else, the default location mysql/...
57
votes
3answers
345k views

How to grant super privilege to the user?

I have created a user and given privileges to the user1. `grant all privileges on db1.* to user1@'%' with grant option; Am using mysql workbench to import dumps to my database. While importing dumps ...
13
votes
5answers
23k views

Alternatives to MySQL Workbench [closed]

I've been running into some problems with MySQL Workbench that I'm not sure will be able to be fixed (namely, what appears to be an old bug that may have resurfaced), so I'd like to be able to find a ...
5
votes
2answers
6k views

How to merge MySQL backup files (*.sql)

We have several MySQL backup files of a database in *.SQL format and we want to restore the database by using these files. However, as the sql files contains "DROP TABLE" definitions, running one ...
4
votes
3answers
1k views

MySQL adds broken comment script after each line

Every time I try to create a table using MySQL Workbench 6.3 CE it adds "broken" comments at the end of the script. Example: I am trying to create a table called "user". This is what the table ...
3
votes
1answer
7k views

What is an equivalent of EXCEPT(in PostgreSQL) in MySQL? [closed]

I want to find out unmatched records of two tables in MySQL.
1
vote
2answers
64 views

Can I use older MySQL workbench with newest MySQL server?

MySQL newbie here. I'm using Ubuntu 16.04 (64-bit). I've successfully installed MySQL Community Server 5.7 and MySQL Community Workbench 6.3. Unable to find these answers in the MySQL forums. I've ...
51
votes
3answers
171k views

How to make MySQL table name case insensitive in Ubuntu?

I am using Ubuntu 13.10 and MySQL 5.6 and I know database name and table name are case sensitive in Ubuntu (and some other *nix environments) by default. Now, I want to make MySQL work as case ...
49
votes
19answers
218k views

Trying to use MySQL Workbench with TCP/IP over SSH - failed to connect

I can't connect using TCP/IP over SSH connection in MySQL Workbench from a PC. What's going on? I created a MySQL 5.1 database on an Ubuntu server mysql.myhost.com. I can access it locally. MySQL ...
10
votes
6answers
62k views

Can't connect to MySQL database over SSH with Workbench

I'm trying to connect to my database via SSH tunneling from one of our web app servers with MySQL Workbench. Here's the basic config; note that I changed some values in the screenshot for security ...
12
votes
1answer
36k views

What is InnoDB Buffer Usage and how to clear it?

In Mysql Workbench when I go in Server > Server Status there is a field called "InnoDB Buffer Usage" It is "95%" even if there is no query running. Why? It affects my performance in my new queries? ...
3
votes
2answers
20k views

Connecting to AWS RDS DBInstance with MySQL workbench

I am trying to evaluate AWS RDS to use as possible DB for our application. I have created a DBInstance(micro) and added IP security group. I am able to connect to the DBInstance from Xampp shell ...
3
votes
2answers
7k views

MySql InnoDB tables are missing after restarting

I had a MySql database with a few InnoDB tables. After restarting the server, and starting MySql Server again, I connected to the MySql Server using MySql Workbench, and couldn't see the database at ...
3
votes
2answers
14k views

High MySQL "InnoDB Writes Per Second" - Can't see the queries?

On our live MySQL 5.5 database server, we use MySQL Workbench for running manual queries, checking running queries to see what's going on, etc. I noticed today that on the "Server Status" tab there's ...
9
votes
1answer
14k views

Error creating foreign key from MySQL Workbench

I'm trying to synchronize schema changes from MySQL Workbench to my database. I'm getting the following error when it tries to create a foreign key: Executing SQL script in server ERROR: Error 1005: ...
4
votes
2answers
17k views

Optimize a MySQL Database using MySQL Workbench

I actually have a few issues. First, I found this information about optimizing: https://stackoverflow.com/questions/5474662/mysql-optimize-all-tables The problem is, I don't seem to have a ...
1
vote
2answers
1k 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: ...
7
votes
2answers
23k views

MySQL tables do not show up in the phpMyAdmin and MySQLWorkbench

I just setup the phpMyAdmin and I have this problem: When I login, I can't see any tables. I had tried this with MySQLWorkbench and I got the same result. Any suggestions ?
4
votes
1answer
5k views

MySql Workbench Data Import .csv

Hi I am trying to use to MySql Workbench Data Import facility to import a .csv file (thousands of records). However it stops importing the first 5 records. After studying the .csv file I could see ...
4
votes
1answer
21k views

MySQL Workbench asking for password

I am trying to set MySQL server on my Windows 7 64 bit machine. I have downloaded MySQL server and MySQLWorkbench. I have started mysql service by command C:\> net start mysql as suggested ...
3
votes
1answer
3k views

prevent MySQL Workbench to add index for foreignkey constraint when it is first part of primary

I know for each foreign key we should make an index on its column, But it is not necessary when that column in first part of PRIMARY index. MySQL accepts this query: CREATE TABLE IF NOT EXISTS `...
3
votes
4answers
7k views

Connect to a remote MySQL Server from a dynamic IP address

My ISP at home uses a dynamic IP address. I'm trying to access a MySQL database at work. How can I connect to it (using MySQL Workbench)? I could grant all privileges to % so that any IP address will ...
3
votes
1answer
25k views

Automatic backups for MySQL Workbench

Is there a way to schedule AUTOMATIC backups for specific tables in MySQL Workbench?
3
votes
4answers
19k views

MySQL Workbench not showing stored procedures that I have created

I have a simple stored procedure that I have just created. I have applied this script to my database This script shows up in the my list of stored procedure However, when I restart MySQL workbench, ...
3
votes
1answer
2k views

getting innodb buffer usage

I am running MySQL 5.5.52 I am trying to see how much of my innodb buffer pool is used. If I run 'show engine innodb status' I see this: ---------------------- BUFFER POOL AND MEMORY -----------------...
2
votes
1answer
14k views

Error Code: 1215. Cannot add foreign key constraint - while creating db in mysql workbench

I created a model for this db in mysql workbench, but now when running the script to create the tables I'm getting: "Error Code: 1215. Cannot add foreign key constraint". The error pops up when it ...
2
votes
2answers
3k views

MySQL Workbench Loses Saved Connections

I've been using MySQL Workbench as my go-to management application for quite some time. However, recently (namely, in my most recent install), it will every so often lose the saved connections I've ...
2
votes
1answer
2k views

Set-up MySQL Server on Windows 7 64-bit

I am trying to install MySQL Server on my Windows-7 64-bit machine. I have downloaded MySQL Server Community Edition and MySQL Workbench. I am trying to start a new Server Instance from Workbench. I ...
1
vote
4answers
2k views

MySQL - Alter Table Fails As Workbench Tries To Create Existing Table

I have been trying to add another column to a table in my database using MySQL Workbench. This generates an 'ALTER TABLE' command which then fails as it fails attempting a 'CREATE TABLE, which it ...
1
vote
2answers
440 views

How to define partition according to Date?

I am currently using MySQL 5.6. In my database, I have a log table called paramlog_ems. It has 2M rows I want like to partition this log table according to Date. Here is the table structure: ...
0
votes
1answer
2k views

Migrating from SQL Server to MySQL using MySQL Workbench tool

I'm trying to migrate few tables from SQL Server to MySQL using MySQL Workbench migration wizard. All work fine for structure migrations but when I go to the data migration section it throws an error ...
0
votes
1answer
2k views

Multiple Result Tabs in Workbench

I have several queries in the editor, each terminating with a semi-colon (I am teaching myself SQL and so in the editor is a mix of queries and notes like below): SELECT * FROM orders WHERE ...
-1
votes
1answer
3k views

Error Code: 1109. Unknown table 'revers' in field list

hello everyone this is a program to reverse a string the program works fine when values are given, but can't fetch the details from the table.If the method is wrong then please tell.thanking everyone ...