MySQL Workbench acquire access for administration?

Question

I run MySQL 5.6 since month and everything went well. Also the MySQL Workbench 6.

I receive two errors if I would like to see the "Server Status".

1st error:

Could not acquire management access for admionistration
RuntimeError: Unable to execute comand chcp. Please make shure that
C:\Windows\System32 directory is in your PATH environment variable.

I checked the windows path variable within Win7 and there exist an entry c:\windows\system32

2nd error:

Unable exception: Current profile has no WMI enable

Any ideas?

Iamat8 · Answer 1 · 2015-12-23T09:19:50.150

11

To resolve the issue, simply click on Manage Server Instances under Server Administration column and close the screen again. Now click on the instance again, check if the issue is fixed or report any bug.

edited Dec 23 '15 at 09:19

answered Feb 04 '14 at 02:50

Iamat8

3,888
9
25
35

Solved, software things ;-) – netadictos Jul 07 '14 at 12:34
I see this is a few months old, still... I couldn't find that option in the Ubuntu version of Workbench. Would anyone know the equivalent command? Thanks. – Diego-MX Nov 26 '14 at 19:30
5

Can anyone confirm is this option is there in workbench version **6.3.6** and later? I cannot seem to find it. – LoneWOLFs Feb 12 '16 at 05:36
4

I am getting this error on v8.0.22 and I can't find `Manage Server Instances under Server Administration` – Jorje12 Nov 23 '20 at 10:54

SakthiSureshAnand · Answer 2 · 2015-08-26T06:07:34.550

8

I thought your MYSQl Service is not yet start. Please Follow the below steps It works me like a charm.
windows + R - Type services.msc Press 'Enter' you could see many services . There is a service called MYSQl56 service if it's Disabled please Start that Service then once again restart the workbench.

edited Aug 26 '15 at 06:07

answered Aug 26 '15 at 06:00

SakthiSureshAnand

1,324
16
32

i have problem while starting this service . dialogue box appears and it says mysql57 on local computer started and then stoped – Rooha Ali Jun 02 '16 at 07:28

score 2 · Answer 3 · answered Apr 26 '16 at 08:28

2

For those who are still facing issue, add "C:\Windows\System32" in "path" Environmental Variable and make sure "MySQL56" service is running.

answered Apr 26 '16 at 08:28

Vijay Nandwana

2,476
4
25
42

score 1 · Answer 4 · answered Aug 19 '21 at 13:03

1

I follow those steps:

I started MySQL80 in Services.
Changed Server -> Management Access Settings -> System Profile, from Windows to Linux so then I entered into Server Status and refreshed.

I hope that can to help anybody.

answered Aug 19 '21 at 13:03

Chester mi niño

71
1
2
7

score 0 · Answer 5 · edited May 23 '17 at 12:09

0

If you got below error when click on Manage Import / Export option

manageserverinstances 0

Previously asked question Backup of mysql DB not being created is answered Exception: Current profile has no WMI enabled

edited May 23 '17 at 12:09

Community

1
1

answered Feb 24 '14 at 12:51

UdayKiran Pulipati

6,579
7
67
92

score 0 · Answer 6 · answered Jul 16 '14 at 15:11

I encountered this issue when trying to install my first mySQL server.

When configuring Remote Management, I overlooked the operating system setting for my server. I was using Windows but the default was set to FreeBSD. Once I changed the server OS setting to Windows, the problem went away.

score 0 · Answer 7 · answered Apr 28 '15 at 14:44

I just encountered exactly the same problem - read lots of suggestions but solutions didn't work for me (I can't un-install MySQL and re-install it on a live server)... ...my resolution, and what worked for me, was to copy chcp.com from C:\Windows\System32\ to C:\Windows\SysWOW64\ I guess it's a path problem between a 32bit version of MySQL/Workbench and the 64bit OS

score 0 · Answer 8 · answered Aug 12 '15 at 08:17

0

I got the same problem after restarting my pc and solved it by just starting wampserver! so the solution is: 1. start wampserver- make sure apache,mysql are running and put all services online. 2.try to reconnect to the database!

answered Aug 12 '15 at 08:17

Nsengiyunva

11
1
9

score 0 · Answer 9 · answered Aug 21 '15 at 03:13

Funnily enough, mine didn't work after the solution given by @mohit, and I'd rather not restart the computer as a work around as some has suggested.

After doing some digging around, I found that the mysql server service was not running

Task Manager --> Services --> [mysqlxx] right click and click start if not running. Note that. Note that [mysqlxx] could be a different format or name where xx are numbers

MySQL Workbench acquire access for administration?

9 Answers9

Linked