MySQL Workbench : MySQL's Open Source GUI for Assisted DB Administration
2
votes
2answers
1k 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 ...
0
votes
1answer
97 views
MySQL Workbench sync keeps requesting the same changes
I am using MySQL Workbench, and when I try to "synchronize" it with my remote database, it keeps detecting some changes to make.
Specifically, the most recurrent ones are:
Dropping foreign keys and ...
3
votes
0answers
293 views
MySQL Workbench model/source synchronize issue
I've been looking all over for any description of an issue like this and I haven't found anything so far.
I am trying to update my MySQL database using MySQL Workbench (5.2.40 CE). I am using the ...
1
vote
0answers
334 views
Migrating from Oracle to MySQL using WorkBench Migration Tool
I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows:
Database ...
1
vote
0answers
60 views
MySQL Workbench and Optional Many's
I have used workbench before to make databases code wise and I just started looking into its EERD functions. I created a small database for a test project and found some odd things about how MySQL ...
1
vote
0answers
134 views
Primary key type change not reflected in foreign keys with MySQL Workbench
I have a problem with MySQL Workbench and primary/foreign keys.
I have some tables with PKs involved in relationship with other tables. If I modify the type of the PK, the type of the FK doesn't ...
1
vote
0answers
127 views
Named Parameters in MySQL Workbench Queries?
In OpenOffice / LibreOffice I'm used to added :prefixed-parameter-names to my queries.
For example:
SELECT name FROM table1 WHERE id = :id
Is there a similar functionality in MySQL Workbench?
0
votes
0answers
25 views
Problems Making Configuration File Changes
I use MySQL 5.5 on both Mac OSX (10.6.8) and Windows 7; in both contexts I use Workbench for my administrative needs. I've recently started tinkering with the configuration files (my.cnf/my.ini), and ...
0
votes
0answers
56 views
Mysql query browser can't connect, Toad, Perl, workbench and command line can?
Mysql query browser used to work fine then suddenly stopped working:
cannot connect to database server. Your connection attempt failed for user 'brianp' from your host to server at viper:3306: Could ...
0
votes
0answers
107 views
Converting data from SQL Server to MySQL using MySQL Workbench and preserving special characters
I am trying to convert a SQL Server database with a SQL_Latin1_General_CP1_CI_AS collation into a MySQL database using MySQL Workbench. I can successfully complete the process without any issues being ...
0
votes
0answers
50 views
Mysql query is very slow
I am developing a website like any other social networking site using mysql.
I wish it give people suggestion to my users, and I have implemented this functionality in my application, but It is ...
0
votes
0answers
29 views
mysql table not updating no errors
i am using mysql 5.2.44 CE revision 9933
i have a table in which i am trying to update a few columns of the rows
i am not using queries, just doing it using the edit table UI provided in the ...
0
votes
0answers
45 views
Mysql notifier Error
i'm getting error when opening Mysql notifier High Severity Error Element 'UpdateCheck' was not found. Line 3, position 2. My mysql server is running. why it's showing this error.
