MySQL Workbench : MySQL's Open Source GUI for Assisted DB Administration

learn more… | top users | synonyms

3
votes
4answers
6k 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 ...
2
votes
1answer
3k views

MySQL Workbench 5.2 edition - Unable to establish the connection

I have installed MySQL (mysql-workbench-gpl-5.2.37-win32.msi ) which is a Windows Installation Workbench. Couple of times, I have done re-installation on my computer. Now, I am not able to establish ...
2
votes
1answer
2k views

MySQL Workbench - Create new server instance error

When attempting to create a new server instance I get an error at the 'Test Settings' step of the creation wizard. The error: What check_admin_commands/local Operation failed: ...
5
votes
1answer
2k 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 ...
4
votes
2answers
2k views

Incremental backups using MySQL Workbench

I need to start doing regular backups of my databases, and I'd like them to be incremental; that is, only backing up the tables that have been changed. I use MySQL Workbench, and I've used the export ...
1
vote
2answers
2k views

I cannot access local database on terminal (MAC)

I have access to my databases on phpmyadmin and mysql Workbench on my local computer but I have a problem when I try to access the server using Terminal. Originally, I had uploaded the databases on ...
0
votes
1answer
2k views

SQL keyword difference between MySQL and Oracle 10g?

Good afternoon, Are there differences between Oracle 10g and MySQL with the CREATE, ALTER, DROP, REF, PRIMARY KEY, FOREGIN KEY and attribute variable type keywords? The reason I ask, is I'm planning ...
2
votes
2answers
9k 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 ?
8
votes
6answers
10k views

Alternatives to MySQL Workbench

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 ...
2
votes
2answers
605 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 ...
1
vote
1answer
664 views

MySQL Workbench: Custom fields for Relationships

I have to manage an existing DB, created "manually" without mysql-wb. I want to draw the printable ER diagram. When I create a relationship, workbench creates its own external key fields. How can I ...
10
votes
6answers
27k 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 ...
2
votes
4answers
2k 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
2answers
2k views

Creating and editing my.cnf by MySQL Workbench?

I just installed MySQL Server and MySQL Workbench on a clean Snow Leopard MacBook. I hooked up Workbench with the server and was able to start the MySQL Server from within the Workbench. I enter the ...
4
votes
1answer
6k 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: ...