Share via

Unable to install MySQL 8.0.33 workbench.

Sitabavani 0 Reputation points
2024-07-10T16:04:25.53+00:00

MySql Error.PNG configuration step: Writing configuration file

Saving my.ini configuration file...

Saved my.ini configuration file.

Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL80 on port 3306.

Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow

Ok.

Successfully added the Windows Firewall rule.

Adding a Windows Firewall rule for MySQL80 on port 33060.

Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow

Ok.

Successfully added the Windows Firewall rule.

Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.

Granted permissions to the data directory.

Adding new service

New service added

Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...

Starting process for MySQL Server 8.0.33...

Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...

C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.33) initializing of server in progress as process 10940

Unknown suffix '.' used for variable 'mysqlx-port' (value '0.0').

option 'mysqlx-port': unsigned value 0 adjusted to 1.

C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'mysqlx-port'.

Parsing options for plugin 'mysqlx' failed.

InnoDB initialization has started.

InnoDB initialization has ended.

unknown variable 'mysqlx_port=0.0'.

The newly created data directory C:\ProgramData\MySQL\MySQL Server 8.0\Data\ by --initialize is unusable. You can remove it.

Aborting

C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.33) MySQL Community Server - GPL.

Process for mysqld, with ID 10940, was run successfully and exited with code 1.

Failed to start process for MySQL Server 8.0.33.

Database initialization failed.

Ended configuration step: Initializing database (may take a long time)

Community Center | Not monitored
0 comments No comments

1 answer

Sort by: Most helpful
  1. JSfx 0 Reputation points
    2024-07-17T09:47:16.66+00:00

    Проблема решена!

    Просто закомментируйте опцию mysqlx_port в шаблоне файла конфигурации и повторите установку, предварительно удалив старую папку данных и саму службу.

    Для редактирования выбираем требуемый шаблон под свою версию

    C:\ProgramData\MySQL\MySQL Installer for Windows\Manifest\Templates

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.