search

TablePlus / DBngin

DB Engine
https://dbngin.com
995 stars 19 forks source link

Mysql won't start #90

Open ricardonolan opened 1 year ago

ricardonolan commented 1 year ago

Please fill out the detail below, it helps me investigate the bug:

  1. Driver (Ex: PostgreSQL 10.0): MySql 8.0.27 Intel|Arm

  2. DBngin build number: 5.2 (54)

  3. macOS version: MacOs Monterey 12.6

  4. The steps to reproduce this issue: 


2022-10-13T08:23:12.136063Z 0 [System] [MY-010116] [Server] /Users/Shared/DBngin/mysql/8.0.27/bin/mysqld (mysqld 8.0.27) starting as process 38594
2022-10-13T08:23:12.137511Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/ricardonolan/Library/Application Support/com.tinyapp.DBngin/Engines/mysql/48C26280-496D-444A-9712-7C25084C1199/ is case insensitive
2022-10-13T08:23:12.138086Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root
2022-10-13T08:23:12.192695Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 46ebbd38-4ad0-11ed-9288-524359f5c3ef.
2022-10-13T08:23:12.220367Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-10-13T08:23:12.221277Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-10-13T08:23:12.221330Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-10-13T08:23:12.224437Z 0 [System] [MY-010910] [Server] /Users/Shared/DBngin/mysql/8.0.27/bin/mysqld: Shutdown complete (mysqld 8.0.27)  MySQL Community Server - GPL.
huyphams commented 1 year ago

Could you please try to press the start/stop again @ricardonolan it said that it failed to initialize the database. If it won't work, please try to delete the server and recreate a new server again. Thanks

ricardonolan commented 1 year ago

Could you please try to press the start/stop again @ricardonolan it said that it failed to initialize the database. If it won't work, please try to delete the server and recreate a new server again. Thanks

Hi @huyphams , thanks for the prompt reply. I did try both clicking the start button again, reloading (changed button to red), and deleting the server and recreating it. I've additionally tried setting it up on a different port, but none of those worked, error was the same every time.