Re: Remote Verbindung
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
Subject
Views
Written By
Posted
953
November 28, 2021 08:48AM
452
November 28, 2021 10:36AM
408
November 28, 2021 12:55PM
456
November 28, 2021 03:50PM
515
November 29, 2021 05:08AM
431
November 29, 2021 10:18AM
384
November 30, 2021 06:31AM
397
November 30, 2021 10:47AM
411
November 30, 2021 12:31PM
451
November 30, 2021 01:51PM
399
December 01, 2021 02:49AM
532
December 01, 2021 11:51AM
499
December 01, 2021 02:15PM
460
December 01, 2021 02:32PM
455
December 02, 2021 07:46AM
383
December 02, 2021 10:05AM
Re: Remote Verbindung
546
December 02, 2021 11:36AM
411
December 02, 2021 11:54AM
320
December 02, 2021 02:13PM
348
December 02, 2021 02:22PM
482
December 03, 2021 07:03AM
376
December 03, 2021 10:10AM
431
December 03, 2021 11:13AM
388
December 03, 2021 12:19PM
466
December 05, 2021 01:14PM
353
December 05, 2021 01:29PM
474
December 05, 2021 02:37PM
408
December 05, 2021 07:45PM
396
December 07, 2021 01:55PM
382
December 07, 2021 02:46PM
330
December 08, 2021 03:20AM