Mysql workbench

Chapter 33 MySQL Workbench MySQL Workbench provides a graphical tool for working with MySQL servers and databases. MySQL Workbench is developed and tested with MySQL Server 8.0. MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those newer server versions. The following discussion briefly describes MySQL Workbench capabilities. For more information, see the MySQL Workbench manual, available at MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers. As well as enabling you to configure connection parameters, MySQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL Editor. This functionality replaces that previously provided by the Query Browser standalone application. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. Server Administration: Enables you to create and administer server instances. Data Migration: Allows you to migrate from Microsoft SQL Server, Sybase ASE, SQLite, SQL Anywhere, PostreSQL, and other RDBMS tables, objects and data to MySQL. Migration also supports migrating from earlier versions of MySQL to the latest releases. MySQL Enterprise Support: Support for Enterprise products such as MySQL Enterprise Backup and MySQL Audit. MySQL Workbench is available in two editions, the Community Edition and the Commercial Edition. The Community Edition is available free of charge. The Commercial Edition provides additional Enterprise features, such as database documentation generation, at low cost.

I had no trouble installing the 32 bit version of mysql workbench this way onto my 32 bit Centos 6 system (by the way, the link posted in the first answer no longer seems to work):yum install mysql-workbench-community-6.1.7-1.el6.i686.rpmLoaded plugins: fastestmirror, refresh-packagekit, securityLoading mirror speeds from cached hostfile * base: mirror.clarkson.edu * epel: mirror.sfo12.us.leaseweb.net * extras: mirrors.kernel.org * updates: mirrors.syringanetworks.netSetting up Install ProcessExamining mysql-workbench-community-6.1.7-1.el6.i686.rpm: mysql-workbench-community-6.1.7-1.el6.i686Marking mysql-workbench-community-6.1.7-1.el6.i686.rpm to be installedResolving Dependencies--> Running transaction check---> Package mysql-workbench-community.i686 0:6.1.7-1.el6 will be installed--> Processing Dependency: libtinyxml.so.0 for package: mysql-workbench-community-6.1.7-1.el6.i686--> Processing Dependency: libzip.so.1 for package: mysql-workbench-community-6.1.7-1.el6.i686--> Running transaction check---> Package libzip.i686 0:0.9-3.1.el6 will be installed---> Package tinyxml.i686 0:2.6.1-1.el6 will be installed--> Finished Dependency ResolutionDependencies Resolved============================================================================================================ Package Arch Version Repository SizeInstalling: mysql-workbench-community i686 6.1.7-1.el6 /mysql-workbench-community-6.1.7-1.el6.i686 113 MInstalling for dependencies: libzip i686 0.9-3.1.el6 base 38 k tinyxml i686 2.6.1-1.el6 epel 47 kTransaction SummaryInstall 3 Package(s)Total size: 113 MTotal download size: 85 kInstalled size: 113 MIs this ok [y/N]: yDownloading Packages:(1/2): libzip-0.9-3.1.el6.i686.rpm | 38 kB 00:00 (2/2): tinyxml-2.6.1-1.el6.i686.rpm | 47 kB 00:00Total 76 kB/s | 85 kB 00:01Running rpm_check_debugRunning Transaction TestTransaction Test SucceededRunning Transaction Installing : libzip-0.9-3.1.el6.i686 1/3 Installing : tinyxml-2.6.1-1.el6.i686 2/3 Installing : mysql-workbench-community-6.1.7-1.el6.i686 3/3 Verifying : tinyxml-2.6.1-1.el6.i686 1/3 Verifying : mysql-workbench-community-6.1.7-1.el6.i686 2/3 Verifying : libzip-0.9-3.1.el6.i686 3/3 Installed: mysql-workbench-community.i686 0:6.1.7-1.el6 Dependency Installed: libzip.i686 0:0.9-3.1.el6 tinyxml.i686 0:2.6.1-1.el6 Complete!

ViewAdd CommentFilesDeveloperEdit SubmissionView Progress LogContributions Description:Trying to migrate from MSSQL 2008R2 to MySQLIt has failed a couple of times already, and I found some posts on changes that have worked for others. I'm getting new failures... can someone advise please?Starting...Migrate Selected Objects....- Migrating...- Migrating schema dbo...- Migrating schema contents for schema dboTraceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\wizard_progress_page_widget.py", line 197, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_object_migration.py", line 117, in task_migrate self.main.plan.migrate() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py", line 510, in migrate self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalogERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalogFailedStarting...Migrate Selected Objects....- Migrating...- Migrating schema dbo...- Migrating schema contents for schema dboTraceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\wizard_progress_page_widget.py", line 197, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_object_migration.py", line 117, in task_migrate self.main.plan.migrate() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py", line 510, in migrate self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalogERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalogFailedHow to repeat:Following migration wizard

I have installed Ubuntu 13.04 and now fully dependent on it. I have worked on mysql query browser in windows to run queries and procedures and programmers ,i could not find any other alternatives in Ubuntu 13.04 which is fast,lightweight,and simple.I had a look on mysql workbench but forums didn't gave any positive feedbacks regarding workbench as it freezes and complicated to use and run simple procedures. what to use that is similar to query browser in Ubuntu. asked Jan 28, 2014 at 13:32 1 emma is an lighter alternative to MySQL Workbench. Reasonably capable with the ability to add databases, tables, execute queries, save query results. You can find in the Ubuntu Software Center, or install it through Terminal with sudo apt-get install emma answered Jan 28, 2014 at 15:52 douggrodouggro2,5773 gold badges19 silver badges22 bronze badges 0 I have been using MySQL in combination with MySQL Workbench since like MySQL Workbench exists. For me it has been THE tool to use. When Workbench is giving me trouble it is ME that started it (by making an SQL statement that hogs MySQL).MySQL Workbench is fast, but not lightweight. It is simple in lay-out but the SQL created with it can be most difficult (but that is not Workbench to blame). I can crash my server with 1 badly created table where SQL needs to match millions and millions of records. But no tool is going to prevent that and again, it is hardly Workbench I can blame. I would