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

learn more… | top users | synonyms

-2
votes
1answer
61 views

Access denied for user 'diduser'@'localhost' to database 'diddata' (1044, 42000)

I am trying to setup a MySQL server and when I went to create a second user it wouldn't give it permissions for the database. I can connect fine as long as I don't specify a database. Access ...
-2
votes
1answer
61 views

Cannot connect to DB server

I have been getting this issue constantly while attempting to set up a database on another computer. I have tried looking up solutions, but nothing I have tried so far has worked, and I have no idea ...
0
votes
1answer
57 views

Parallel mysqlimport Syntax Wrong?

I'm trying to import a large 70GB+ database (all InnoDB) using mysqlimport. This is a development system on Windows using WAMP server. MySQL 5.6.17. I'm getting the following error: mysqlimport: ...
0
votes
1answer
265 views

MySQL Workbench: 'Disk Space in Data Dir' limited to 20G [closed]

I have an OVH private server (Ubuntu 12.04, 8 GB RAM, i3-2130, 2x500 GB HDD) and I'm dealing with MySQL administration. I have installed MySQL Community server 5.6.16 correctly and it works fine(it ...
0
votes
1answer
969 views

How do I connect to an AWS RDS with MySQL Workbench? [closed]

I've read this documentation and several other sources but to no avail: I cannot connect to my MySQL instance from MySQL Workbench. I can connect to my RDS instance through EC2, but I cannot dump ...
-1
votes
6answers
1k views

Total newb having SSH tunnel and remote MySQL access problems [closed]

I don't often work with linux or need to SSH tunnel into remote MySQL databases, so pardon my ignorance. I'm using Windows 7 and am needing to connect to a remote MySQL instance on a Linux server. ...
-1
votes
1answer
163 views

Copying raw mysql files to Windows 7 MySQL 5.6 obtained via mysqlhotcopy from Linux MySQL 5.1 [closed]

Assuming I only have access to the raw files (.myd, .myi, .frm), would I simply copy+paste mysql db files obtained from /var/lib/mysql/mydb to C:\Program Files\MySQL\MySQL Workbench CE ...
1
vote
1answer
77 views

Debian server, Workbench client or server side?

We have a server running Debian squeeze with mysql and until now we manage the db through phpMyAdmin. In this question I was told that Workbench represents a better choice than PMA in terms of ...
2
votes
3answers
959 views

unable to install MySql Workbench

When I try to install MySql Workbench using the yum command : yum install mysql-workbench-gpl-5.2.45-1fc17.i686.rpm I get these errors : Error: Package: mysql-workbench-gpl-5.2.45-1fc17.i686 ...
1
vote
1answer
256 views

Create dump of database schema remotely

I have a connection to remote Mysql database. (i'm using MySQL Workbench). I'd like to copy whole structure of the database, (without data) to create identical structure on my local machine. Is it ...
1
vote
1answer
974 views

How to find table engine in MySQL Workbench?

I've just installed MySQL Workbench 5.2.39 and I'm currently viewing one of my databases through the 'Schema' panel in a 'SQL Editor' tab. I can see all of my database's tables under 'Tables', but no ...
2
votes
3answers
3k views

MySQL Workbench: Orphaned document changes detected

Each time I open MySQL Workbench, I get this annoying message at the bottom of the screen saying "Orphaned document changes detected". It comes up whether I close all the SQL Editor workspaces or not. ...
1
vote
2answers
984 views

Cannot connect to a MySql Server using MySql Workbench with no apparent reason

I can't connect via TCP/IP to the MySQL server. The server is installed in a Debian Linux and there's a PostGreSQL server running at the same time. (which is working fine and has tcp/ip connection ...
3
votes
1answer
488 views

How to send logs to table so that we can view them in Workbench?

At log tab, it shows : Your current Log Destination is set to FILE. For logs to be viewed within Workbench they must be configured to be sent to TABLE. This ...
1
vote
1answer
4k views

Exporting MySQL without trigger data?

I'm using the MySQL Workbench tool to export a database. However, the database data includes trigger data as well. How can I ignore the triggers and not include them in the generated SQL dump file?
1
vote
2answers
611 views

Tunnel to MySql via workbench not working when regular ssh tunnel works

I am trying to access a mysql server via an SSH tunnel. My understanding is that this should be supported natively in Mysql Workbench (5.2.35 on Ubuntu 10). The following works: Open shell ssh -f ...
2
votes
1answer
204 views

How to stop logging activity from MySQL workbench?

I have enabled the query and slow_query logging in MySQL, but I'm getting new entries every second of the type: 2 Query show global status 110925 21:18:18 1 Query select 1 I've ...
3
votes
1answer
260 views

MySQLWorkbench Connection Problems

I have problems connecting to my MySQL server using MySQLWorkbench. I believe it's some type of permissions issue, to ensure I am able to use this, can you help me with the necessary setup steps? I ...
0
votes
1answer
2k views

Why can I manage my server using MySQL Worckbench (WMI Status…)

I'm trying to manage my mysql server using Workbench 5.2.31 CE Rev 7115 with mysql 5.5.8 on Windows Server 2003 but I'm getting this error: RuntimeError: Could not initialize WMI interface: ...
0
votes
2answers
296 views

MySQL maxed out memory usage problem

I am currently ingesting millions of rows of data into a MySQL database. I am monitoring the server status locally on my machine using MySQL Workbench. The application is showing that the memory is ...
-1
votes
2answers
940 views

Using cPanel to setup SSH for MySQL [closed]

Using cPanel as the only way to access the server, is it possible to setup a connect to MySQL so I can administor the MySQL database remotely? i.e using MySQL WorkBench?
1
vote
2answers
1k views

MySQL Workbench HTTP tunnel

Is there way in MySQL Workbench to connect to a database via HTTP Tunnel? I've used HTTP tunnel for a while with Navicat and I would like to connect on same way to a remote databases with MySQL ...
1
vote
2answers
2k views

Unknown MySQL server host - connection problem

I am new to databases and I have been asked to look at a few tables and see how many records they have and some other information. I cannot access phpMyAdmin through cPanel, which is how I've always ...