更新MySQL Workbech8.0.18后，不显示任何数据库

Question

在上对MySQL工作台进行了8.0.18版本的更新，从那时起，我的数据库就不再出现了，因为连接错误，我的网站也没有在本地主机上启动。

在文件夹中: OS ~/Library/Application\ Support/MySQL/ Workbench / I删除了wb_options.xml和wb_state.xml文件并重新启动了Workbench，但没有显示数据库。

尝试进入命令行，在那里我可以输入以下命令：

echo 'export PATH=/usr/local/mysql/bin:$PATH' >> ~/.bash_profile
. ~/.bash_profile
mysql -u root -p
mysql> SET GLOBAL innodb_fast_shutdown = 1;
mysql_upgrade -u root -p

输出：

➜  mysql mysql -u root -p            
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 48
Server version: 8.0.18 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SET GLOBAL innodb_fast_shhutdown = 1;
ERROR 1193 (HY000): Unknown system variable 'innodb_fast_shhutdown'

mysql> SET GLOBAL innodb_fast_shutdown = 1;
Query OK, 0 rows affected (0,00 sec)

mysql> mysql_upgrade -u root -p

没有进一步的输出。

看了看wb.log

07:45:48 [INF][      Workbench]: Starting up Workbench
07:45:48 [INF][   WBContext UI]: Initializing workbench context UI with these values:
      base dir: /Applications/MySQLWorkbench 2.app/Contents/Resources
    plugin path: /Applications/MySQLWorkbench 2.app/Contents/PlugIns
    struct path: /Applications/MySQLWorkbench 2.app/Contents/Resources/grt
    module path: /Applications/MySQLWorkbench 2.app/Contents/PlugIns:/Applications/MySQLWorkbench 2.app/Contents/Resources/plugins
    library path: /Applications/MySQLWorkbench 2.app/Contents/Resources/libraries
    user data dir: /Users/<USERNAME>/Library/Application Support/MySQL/Workbench
      open at start: -psn_0_5371167
    open type:
    run at startup:
    run type:
    Force SW rendering: No
    Force OpenGL: No
    quit when done: No
07:45:48 [INF][      WBContext]: WbContext::init
07:45:48 [INF][      WBA]: Looking for extension modules for WBA...
07:45:48 [INF][      WBA]: 0 extension modules found
07:45:48 [WRN][      grt]: /Users/<USERNAME>/Library/Application Support/MySQL/Workbench/connections.xml:27: link 'D61B9071-5CA5-47E8-AF17-EC4DB12CA9B2' <object GrtObject> key=owner could not be resolved**
07:45:48 [INF][      WBContext]: System info:
  MySQL Workbench Community (GPL) for Mac OS X version 8.0.18 CE build 15329599 (64 bit)
  Configuration Directory: /Users/<USERNAME>/Library/Application Support/MySQL/Workbench
  Data Directory: /Applications/MySQLWorkbench 2.app/Contents/Resources
    Cairo Version: 1.10.2   OS: macOS 10.15.x Catalina x86_64   CPU: 8x Intel(R) Core(TM) i7-4870HQ CPU @ 2.50GHz - 16.00GiB RAM No video adapter info available

07:45:48 [ERR][      WBContext]: Unknown file type -psn_0_5371167
07:45:59 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO) 07:45:59 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user
'root'@'localhost' (using password: NO) 07:46:06 [ERR][SQL Editor Form]: Can't restore default schema (develop): Unknown database
'develop' 07:46:06 [ERR][SQL Editor Form]: Can't restore default schema (develop): Unknown database 'develop' 07:46:06 [INF][SQL Editor
Form]: Opened connection 'Local instance 3306' to MySQL Community Server - GPL version 8.0.18 07:46:35
[INF][wb_admin_control.py:query_server_installation_info:860]: Currently connected to MySQL server version '8.0.18', conn status = True, active plugins = ['INNODB_INDEXES', 'sha256_password', 'INNODB_CMPMEM_RESET', 'INNODB_BUFFER_POOL_STATS', 'CSV', 'mysql_native_password', 'INNODB_FT_BEING_DELETED', 'INNODB_BUFFER_PAGE', 'INNODB_CMP_PER_INDEX_RESET', 'INNODB_TABLESTATS', 'ARCHIVE', 'INNODB_FT_INDEX_CACHE', 'INNODB_CMP', 'INNODB_FT_CONFIG', 'InnoDB', 'INNODB_FT_DEFAULT_STOPWORD', 'INNODB_TRX', 'binlog', 'INNODB_TABLES', 'INNODB_COLUMNS', 'INNODB_CMPMEM', 'INNODB_FT_INDEX_TABLE', 'sha2_cache_cleaner', 'MEMORY', 'PERFORMANCE_SCHEMA', 'BLACKHOLE', 'caching_sha2_password', 'INNODB_SESSION_TEMP_TABLESPACES', 'INNODB_CACHED_INDEXES',
'TempTable', 'INNODB_VIRTUAL', 'MRG_MYISAM', 'INNODB_CMP_PER_INDEX', 'INNODB_FT_DELETED', 'mysqlx_cache_cleaner', 'INNODB_TABLESPACES',
'INNODB_METRICS', 'mysqlx', 'MyISAM', 'INNODB_TEMP_TABLE_INFO', 'INNODB_CMP_RESET', 'keyring_file', 'ngram', 'INNODB_BUFFER_PAGE_LRU']
07:46:49 [WRN][wb_admin_control.py:exec_query:623]: Error executing query SELECT name, timer_name FROM performance_schema.setup_timers: 
07:47:32 [WRN][         mforms]: Resource file not found: mysql-logo-80.png
07:47:33 [WRN][         mforms]: Resource file not found: mysql-logo-80.png
07:53:38 [WRN][         mforms]: Resource file not found: db.StoredProcedure.16x16.png
07:53:38 [WRN][         mforms]: Resource file not found: db.Function.16x16.png
07:53:38 [WRN][         mforms]: Resource file not found: db.Grants.16x16.png
07:54:04 [INF][      Workbench]: Shutting down Workbench
07:54:04 [INF][      Workbench]: Workbench shutdown done ➜  log

高亮显示注意到connections.xml的行无法解析。不知道这个通知有什么影响。

任何帮助都是非常感谢的！

谢谢您抽时间见我。

更新1：

➜  bin mysql_upgrade -u root -p
Enter password: 

The mysql_upgrade client is now deprecated. The actions executed by
the upgrade client are now done by the server. To upgrade, please
start the new MySQL binary with the older data directory. Repairing
user tables is done automatically. Restart is not required after
upgrade. The upgrade process automatically starts on running a new
MySQL binary with an older data directory. To avoid accidental
upgrades, please use the --upgrade=NONE option with the MySQL binary.
The option --upgrade=FORCE is also provided to run the server upgrade
sequence on demand. It may be possible that the server upgrade fails
due to a number of reasons. In that case, the upgrade sequence will
run again during the next MySQL server start. If the server upgrade
fails repeatedly, the server can be started with the --upgrade=MINIMAL
option to start the server without executing the upgrade sequence,
thus allowing users to manually rectify the problem. ➜  bin

更新2

试图通过命令行连接到数据库，我最好的猜测是我的数据库已经消失了：

➜bin echo 'export =/usr/local/mysql/ bin：$PATH‘>> ~/..bash_profile➜bin。~/..bash_profile -u bin mysql -p -h 127.0.0.1开发输入密码:错误1049 (42000)：未知数据库“开发”

是否有可能通过任何改变来检查数据库“开发”是否真的消失了？如果是这样的话，是否可以用TimeMachine恢复它？

我不知道会发生什么，但是升级工作台已经成为我的噩梦。

Answer 1

您突出显示的警告涉及文件的反序列化问题，并不严重。

你真正的问题是你不能连接。您将一个参数传递给Workbench 07:45:48 [ERR][ WBContext]: Unknown file type -psn_0_5371167，它试图将其解释为连接名称。还请参阅日志文件顶部的上下文初始化值。有一个条目open at start: -psn_0_5371167证实了我上面提到的内容。尝试在没有任何参数的情况下启动Workbench。

根据this question的说法，PSN参数是一个进程序列号，仅在第一次启动时才传递给GUI应用程序。自从你下载了工作台之后，你有没有尝试过另一个工作台的启动？

附带注意:工作台确实应该知道这样的参数，并忽略它。