Mysql – Why can’t I manage the server using MySQL Worckbench (WMI Status…)

MySQL

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: Workbench.wmiOpenSession(); Internal error: Instantion of IWbemLocatio failed.

Internal Error: WMI status code text creation failed

I can use [SQL Development], [Data Modeling], but not [Server Administration]…

Best Answer

I'm not familiar with that tool, but if it's a WMI problem, you might want to make sure WMI is enabled in Windows Server and that any firewall ports are open that are used by WMI.

Maybe this will help, or Google for "enable wmi in windows 2003" for other possibly relevant information.

Related Solutions

Mysql – Best Method or Tool to Migrate from MySQL to SQL Server

Not sure if it is the "best" but here is a tool http://www.dbload.com/

I'd probably use DTS / SSIS (with ODBC MySql Driver) that comes with Sql Server depending on how many objects you are transferring it may take awhile to get all the mappings/identity/defaults correct

Mysql – Can’t install MySQL

Try these:

sudo apt-get purge mysql-common mysql-server-5.1
sudo apt-get install mysql-server

Note that you don't need to purge mysql-server since it's just a meta-package (i.e. it's a convenience package containing just dependency info). Also, pay attention to the output of the purge option. It might display directories that aren't purged, and then you can remove those manually.

Best Answer

Related Solutions

Mysql – Best Method or Tool to Migrate from MySQL to SQL Server

Mysql – Can’t install MySQL

Related Topic