Initializing database mysql ошибка

Beginning configuration step: Initializing Database
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.11...
Starting process with command: C:Program FilesMySQLMySQL Server 8.0binmysqld.exe --defaults-file="C:ProgramDataMySQLMySQL Server 8.0my.ini" --console --initialize-insecure=on...
2018-06-26T08:44:42.036600Z 0 [ERROR] [MY-011071] [Server] Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0')
2018-06-26T08:44:42.036600Z 0 [ERROR] [MY-011071] [Server] C:Program FilesMySQLMySQL Server 8.0binmysqld.exe: Error while setting value '0.0' to 'lower_case_table_names'
2018-06-26T08:44:42.036600Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-06-26T08:44:42.036600Z 0 [Note] [MY-010120] [Server] Binlog end
Process for mysqld, with ID 3232, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.11.
Database initialization failed.
Ended configuration step: Initializing Database

I am having this error in log during the installing of MySQL on the application configuration part.

Resolved following these steps:
— Rollback installation until initial page and choose remove mysql server
— Uninstall from add/remove programs mysql community installer
— reboot
— install version mysql-installer-web-community-5.7.22.1 and select update when it asks.
— done

The only way to get rid of this error is by allowing MySQL Installer to update when it prompts to do so at the beginning of the installation. Please note that you will get this error if you didn’t allow the installer to update.

Updating lower_case_table_names = 0 in my.ini doesn’t fix this because MySql will re-initialize it to 0.0 everytime before running the scripts.

If you didn’t allow updates, you will need to uninstall all components of MySql and run the installer again and let it update.

answered Jul 8, 2018 at 5:41

First you have to uninstall mysql:

Step 1. control panel->programs and then uninstall whole mysql.

Step 2. delete folder MySQL from the following path.

1. C:Program FilesMySQL
2. C:Program Files (x86)MySQL
3. C:ProgramDataMySQL (your programdata folder is hidden so you have to unhide from c drive->views->options->view ->show hidden files)
   4.C:Usershp(your pc name)AppDataRoamingMySQL

Step 3. windows+r write regedit.exe enter and follow the path and delete mysql ComputerHKEY_LOCAL_MACHINESYSTEMControlSet001Services

Step 4. control panel->administrative tool->services then find mysql copy name then open cmd run as administrative write (sc Delete «mysql name that you copied»)enter.

Now you can install MySQL

answered Jul 19, 2018 at 10:49

When I downgrade MySQL from 8.0.11 to 5.7.22, I encountered this error. Spend a lot of time to fix the bug. Finally, I fix this problem by the following steps:

1. uninstall all the related features with MySql( use Control Panel > Programs and Features)
2. go to C: drive, make all hidden files visible(view > hidden items), find ProgramData file
3. delete the MySql file inside hidden ProgramData file manually.
   Make sure all the MySQL files are deleted, reinstall MySQL. It works for me. I successfully installed MySQL 5.7.22 without any problem.

My Guess: This error probably will happen if you are second or third time to install MySql server. It seems like the error happens because the old MySql files are not deleted completely. Usually, we all think that after we uninstall the application, the files are deleted from program files, it is clean, everything was done. However, there still some files hidden from us. We have to delete them by ourselves.

answered Jul 25, 2018 at 21:40

On bug page, last comment states that the latest installer solves this problem.
For me not. The following steps made me a clean install (after get the latest installer):

When it fails on database initialization step just cancel it back to the installer’s main page where you can see installed MySQL server with a reconfigure option.

Now edit the my.ini and set the

"lower_case_table_names=0.0"

to

"lower_case_table_names=0"

Click on reconfigure and now it goes over on this problem.

Hope it helps.

I faced the same problem with 1.4.25 installer and resolved that by doing the following steps [without updating the installer]

1. There is a folder MySQL Installer for WindowsManifestTemplates
2. In Templates folder there are few text files which are there to be used as a template during my.ini generation. I have commented out the line lower_case_table_names=

Now I execute the configuration process using installer and it executes without any error.Also I add the variable later and restart the server.

answered Jul 24, 2018 at 20:28

When I installed mysql server, wizard of installation was stooped at the point initializing database (if necessary) for that I did.

1. remove mysql folder from ‘C:ProgramData’ folder. Note: ProgramData is hidden. You need to make it visible.
2. Uninstall mysql server if it was in the list of installed programs in control panel.
3. Download mysql-installer-web-community-8.0.13.0 and install it again.

I had the same problem, tried to change my.ini did’t work, so I uninstalled the SQL server, then I google my operating system + Install MySQL videos (In my case «Install MySQL on Windows 8»), then I installed MySQL 5.6.26 then worked.
I think the newer MySQL doesn’t support certain old operating system.

Beginning configuration step: Initializing Database
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.11...
Starting process with command: C:Program FilesMySQLMySQL Server 8.0binmysqld.exe --defaults-file="C:ProgramDataMySQLMySQL Server 8.0my.ini" --console --initialize-insecure=on...
2018-06-26T08:44:42.036600Z 0 [ERROR] [MY-011071] [Server] Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0')
2018-06-26T08:44:42.036600Z 0 [ERROR] [MY-011071] [Server] C:Program FilesMySQLMySQL Server 8.0binmysqld.exe: Error while setting value '0.0' to 'lower_case_table_names'
2018-06-26T08:44:42.036600Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-06-26T08:44:42.036600Z 0 [Note] [MY-010120] [Server] Binlog end
Process for mysqld, with ID 3232, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.11.
Database initialization failed.
Ended configuration step: Initializing Database

I am having this error in log during the installing of MySQL on the application configuration part.

Resolved following these steps:
— Rollback installation until initial page and choose remove mysql server
— Uninstall from add/remove programs mysql community installer
— reboot
— install version mysql-installer-web-community-5.7.22.1 and select update when it asks.
— done

The only way to get rid of this error is by allowing MySQL Installer to update when it prompts to do so at the beginning of the installation. Please note that you will get this error if you didn’t allow the installer to update.

Updating lower_case_table_names = 0 in my.ini doesn’t fix this because MySql will re-initialize it to 0.0 everytime before running the scripts.

If you didn’t allow updates, you will need to uninstall all components of MySql and run the installer again and let it update.

answered Jul 8, 2018 at 5:41

First you have to uninstall mysql:

Step 1. control panel->programs and then uninstall whole mysql.

Step 2. delete folder MySQL from the following path.

1. C:Program FilesMySQL
2. C:Program Files (x86)MySQL
3. C:ProgramDataMySQL (your programdata folder is hidden so you have to unhide from c drive->views->options->view ->show hidden files)
   4.C:Usershp(your pc name)AppDataRoamingMySQL

Step 3. windows+r write regedit.exe enter and follow the path and delete mysql ComputerHKEY_LOCAL_MACHINESYSTEMControlSet001Services

Step 4. control panel->administrative tool->services then find mysql copy name then open cmd run as administrative write (sc Delete «mysql name that you copied»)enter.

Now you can install MySQL

answered Jul 19, 2018 at 10:49

When I downgrade MySQL from 8.0.11 to 5.7.22, I encountered this error. Spend a lot of time to fix the bug. Finally, I fix this problem by the following steps:

1. uninstall all the related features with MySql( use Control Panel > Programs and Features)
2. go to C: drive, make all hidden files visible(view > hidden items), find ProgramData file
3. delete the MySql file inside hidden ProgramData file manually.
   Make sure all the MySQL files are deleted, reinstall MySQL. It works for me. I successfully installed MySQL 5.7.22 without any problem.

My Guess: This error probably will happen if you are second or third time to install MySql server. It seems like the error happens because the old MySql files are not deleted completely. Usually, we all think that after we uninstall the application, the files are deleted from program files, it is clean, everything was done. However, there still some files hidden from us. We have to delete them by ourselves.

answered Jul 25, 2018 at 21:40

On bug page, last comment states that the latest installer solves this problem.
For me not. The following steps made me a clean install (after get the latest installer):

When it fails on database initialization step just cancel it back to the installer’s main page where you can see installed MySQL server with a reconfigure option.

Now edit the my.ini and set the

"lower_case_table_names=0.0"

to

"lower_case_table_names=0"

Click on reconfigure and now it goes over on this problem.

Hope it helps.

I faced the same problem with 1.4.25 installer and resolved that by doing the following steps [without updating the installer]

1. There is a folder MySQL Installer for WindowsManifestTemplates
2. In Templates folder there are few text files which are there to be used as a template during my.ini generation. I have commented out the line lower_case_table_names=

Now I execute the configuration process using installer and it executes without any error.Also I add the variable later and restart the server.

answered Jul 24, 2018 at 20:28

When I installed mysql server, wizard of installation was stooped at the point initializing database (if necessary) for that I did.

1. remove mysql folder from ‘C:ProgramData’ folder. Note: ProgramData is hidden. You need to make it visible.
2. Uninstall mysql server if it was in the list of installed programs in control panel.
3. Download mysql-installer-web-community-8.0.13.0 and install it again.

I had the same problem, tried to change my.ini did’t work, so I uninstalled the SQL server, then I google my operating system + Install MySQL videos (In my case «Install MySQL on Windows 8»), then I installed MySQL 5.6.26 then worked.
I think the newer MySQL doesn’t support certain old operating system.

I’m trying to install MySQL 8.0.19 on my windows 10. I have an issue when trying to initializing database. It is failed with a message «may take a long time». Below is the log of configuration:

Beginning 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 Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

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

Deleting the data directory from a previous (failed) configuration...
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.19...
Starting process with command: C:Program FilesMySQLMySQL Server 8.0binmysqld.exe --defaults-file="C:ProgramDataMySQLMySQL Server 8.0my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
C:Program FilesMySQLMySQL Server 8.0binmysqld.exe (mysqld 8.0.19) initializing of server in progress as process 12572
Unable to create temporary file; errno: 2
InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
Data Dictionary initialization failed.
The newly created data directory C:ProgramDataMySQLMySQL Server 8.0Data by --initialize is unusable. You can remove it.
Aborting
C:Program FilesMySQLMySQL Server 8.0binmysqld.exe: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.
Process for mysqld, with ID 12572, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.19.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

anyone can help me with this problem?

asked Feb 12, 2020 at 10:09