Re: Remote Verbindung

[Friedrich Bezucha]

Ich kann den PC mit wo der Server MySQL installiert ist mit ping 192.168.0.35 positiv anpingen, aber ich kann mich nicht bei MySQL als Benutzer anmelden. Das ist jetzt das LOG-File.
18:19:41 [ERR][ Workbench]: Console redirection failed.
18:19:41 [INF][ Workbench]: Starting up Workbench
18:19:41 [INF][ Workbench]: Current environment:
Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0\MySQLWorkbench.exe"
CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0
HasShutdownStarted: False
OSVersion: Microsoft Windows NT 6.2.9200.0
SystemDirectory: C:\WINDOWS\system32
TickCount: 25352750
UserInteractive: True
Version: 4.0.30319.42000
WorkingSet: 43028480
18:19:41 [INF][ Workbench]: Environment variables:
COMPUTERNAME = STANDPC
USERPROFILE = C:\Users\fried
HOMEPATH = \Users\fried
LOCALAPPDATA = C:\Users\fried\AppData\Local
PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
PROCESSOR_ARCHITECTURE = AMD64
CommonProgramW6432 = C:\Program Files\Common Files
CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
ProgramFiles(x86) = C:\Program Files (x86)
PROCESSOR_LEVEL = 6
LOGONSERVER = \\STANDPC
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
HOMEDRIVE = C:
SystemRoot = C:\WINDOWS
SESSIONNAME = Console
ALLUSERSPROFILE = C:\ProgramData
DriverData = C:\Windows\System32\Drivers\DriverData
FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
APPDATA = C:\Users\fried\AppData\Roaming
Path = C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Program Files (x86)\Common Files\Acronis\VirtualFile\;C:\Program Files (x86)\Common Files\Acronis\VirtualFile64\;C:\Program Files (x86)\Common Files\Acronis\FileProtector\;C:\Program Files (x86)\Common Files\Acronis\FileProtector64\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Server 8.0\bin;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\fried\AppData\Local\Microsoft\WindowsApps;
USERNAME = Opa
OneDrive = C:\Users\fried\OneDrive
TEMP = C:\Users\fried\AppData\Local\Temp
CommonProgramFiles = C:\Program Files\Common Files
OS = Windows_NT
USERDOMAIN_ROAMINGPROFILE = STANDPC
PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
OneDriveConsumer = C:\Users\fried\OneDrive
USERDOMAIN = STANDPC
SystemDrive = C:
FPS_BROWSER_USER_PROFILE_STRING = Default
ProgramFiles = C:\Program Files
NUMBER_OF_PROCESSORS = 2
ComSpec = C:\WINDOWS\system32\cmd.exe
TMP = C:\Users\fried\AppData\Local\Temp
ProgramData = C:\ProgramData
ProgramW6432 = C:\Program Files
windir = C:\WINDOWS
PROCESSOR_REVISION = 5e03
PUBLIC = C:\Users\Public
18:19:41 [INF][ Workbench]: Current version given by meta info is: 8.0.26
18:19:41 [INF][ Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Program Files (x86)\Common Files\Acronis\VirtualFile\;C:\Program Files (x86)\Common Files\Acronis\VirtualFile64\;C:\Program Files (x86)\Common Files\Acronis\FileProtector\;C:\Program Files (x86)\Common Files\Acronis\FileProtector64\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Server 8.0\bin;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\fried\AppData\Local\Microsoft\WindowsApps;
18:19:41 [INF][ mforms managed]: Initializing mforms wrapper
18:19:41 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: C:\Program Files\MySQL\MySQL Workbench 8.0
plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0
struct path:
module path: C:\Program Files\MySQL\MySQL Workbench 8.0/modules
library path: C:\Program Files\MySQL\MySQL Workbench 8.0
user data dir: C:\Users\fried\AppData\Roaming\MySQL\Workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
18:19:41 [INF][ WBContext]: WbContext::init
18:19:41 [INF][ WBA]: Looking for extension modules for WBA...
18:19:41 [INF][ WBA]: 0 extension modules found
18:19:42 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
18:19:42 [WRN][ grt]: C:\Users\fried\AppData\Roaming\MySQL\Workbench\connections.xml:27: link '{DFC61C33-8E1B-478F-BC29-63F6620E41EC}' <object GrtObject> key=owner could not be resolved
18:19:42 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
18:19:42 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Windows version 8.0.26 CE build 972499 (64 bit)
Configuration Directory: C:\Users\fried\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0
Cairo Version: 1.17.4
OS: Microsoft Windows 10 Home
CPU: 2x Intel(R) Celeron(R) CPU G3900 @ 2.80GHz, 8.0 GiB RAM
Active video adapter NVIDIA GeForce GT 710
Installed video RAM: 1024 MB
Current video mode: 1920 x 1080 x 4294967296 Farben
Used bit depth: 32
Driver version: 27.21.14.5671
Installed display drivers: C:\WINDOWS\System32\DriverStore\FileRepository\nv_dispi.inf_amd64_60daf66a00f2e0b6\nvldumdx.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nv_dispi.inf_amd64_60daf66a00f2e0b6\nvldumdx.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nv_dispi.inf_amd64_60daf66a00f2e0b6\nvldumdx.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nv_dispi.inf_amd64_60daf66a00f2e0b6\nvldumdx.dll
Current user language: Deutsch (Österreich)

18:19:42 [INF][ Workbench]: UI is up
18:19:42 [INF][ Workbench]: Running the application
18:19:46 [INF][SQL Editor Form]: Opened connection 'Bezucha' to MySQL Community Server - GPL version 8.0.26
18:19:46 [INF][ WQE.net]: Launching SQL IDE
18:19:47 [INF][ WQE.net]: SQL IDE UI is ready
18:20:41 [ERR][wb_admin_control.py:get_config_options:760]: Could not open the file "C:\ProgramData\MySQL\MySQL Server 5.5\my.ini": [Errno 2] No such file or directory: 'C:\\ProgramData\\MySQL\\MySQL Server 5.5\\my.ini'
18:20:41 [INF][wb_admin_control.py:query_server_installation_info:860]: Currently connected to MySQL server version '8.0.26', conn status = True, active plugins = ['INNODB_FT_DEFAULT_STOPWORD', 'INNODB_BUFFER_PAGE', 'InnoDB', 'mysql_native_password', 'INNODB_TABLESTATS', 'INNODB_CACHED_INDEXES', 'ARCHIVE', 'INNODB_FT_CONFIG', 'INNODB_TRX', 'sha256_password', 'binlog', 'sha2_cache_cleaner', 'INNODB_CMPMEM', 'INNODB_FT_INDEX_TABLE', 'INNODB_FT_BEING_DELETED', 'INNODB_VIRTUAL', 'caching_sha2_password', 'INNODB_FT_INDEX_CACHE', 'ngram', 'INNODB_SESSION_TEMP_TABLESPACES', 'INNODB_CMP_PER_INDEX', 'INNODB_TEMP_TABLE_INFO', 'MEMORY', 'INNODB_CMPMEM_RESET', 'INNODB_CMP_RESET', 'INNODB_CMP', 'INNODB_TABLES', 'mysqlx', 'daemon_keyring_proxy_plugin', 'INNODB_METRICS', 'INNODB_COLUMNS', 'CSV', 'INNODB_TABLESPACES', 'TempTable', 'MRG_MYISAM', 'INNODB_BUFFER_POOL_STATS', 'mysqlx_cache_cleaner', 'INNODB_CMP_PER_INDEX_RESET', 'PERFORMANCE_SCHEMA', 'INNODB_INDEXES', 'BLACKHOLE', 'INNODB_FT_DELETED', 'MyISAM', 'INNODB_BUFFER_PAGE_LRU']
18:20:41 [WRN][wb_admin_control.py:acquire_admin_access:284]: Could not detect target OS details
18:20:41 [ERR][ wmi]: Could not connect to target machine. Error: Zugriff verweigert

18:20:46 [ERR][ pymforms]: Unhandled exception in Python code:
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\wb_admin_grt.py", line 303, in _sidebar_entry_clicked
self.open_into_section(entry_id)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\wb_admin_grt.py", line 329, in open_into_section
page = page_class(self.ctrl_be, self.server_profile, self.admin_tab)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\wb_admin_server_status.py", line 234, in __init__
self.status = wb_admin_monitor.WbAdminMonitor(server_profile, self.ctrl_be)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\wb_admin_monitor.py", line 251, in __init__
self.mon_be = wba_monitor_be.WBAdminMonitorBE(UPDATE_INTERVAL, server_profile, ctrl_be, self.widgets, self.cpu_widget, sql)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\wba_monitor_be.py", line 398, in __init__
self.wmimon = WMIStats(ctrl_be, server_profile, cpu_widget)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\wba_monitor_be.py", line 343, in __init__
raise Exception("Current profile has no WMI enabled") # TODO Should be better message
Exception: Current profile has no WMI enabled
18:21:51 [INF][ WQE.net]: Shutting down SQL editor (Bezucha)
18:21:54 [INF][ Workbench]: Shutting down Workbench
18:21:54 [INF][ mforms managed]: Shutting down mforms wrapper
18:21:54 [INF][ Workbench]: Done