Error installing mysql

Question

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 Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.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 Files\MySQL\MySQL Server 8.0\bin\mysqld.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.

Are there any update for answering this question. I face the same problem — Abdulwahid
– Abdulwahid, Commented Jul 19, 2018 at 10:17

Rafael Souza · Accepted Answer · 2018-07-21 01:31:36Z

5

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

answered Jul 21, 2018 at 1:31

Rafael Souza

1571 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kevin Ramirez Zavalza Over a year ago

Worked perfectly, I was fighting to install it in my new notebook, thanks for sharing the answer.

J. M. Arnold · Accepted Answer · 2021-05-22 23:28:09Z

4

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.

C:\Program Files\MySQL
C:\Program Files (x86)\MySQL
C:\ProgramData\MySQL (your programdata folder is hidden so you have to unhide from c drive->views->options->view ->show hidden files) 4.C:\Users\hp(your pc name)\AppData\Roaming\MySQL

Step 3. windows+r write regedit.exe enter and follow the path and delete mysql Computer\HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\

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

edited May 22, 2021 at 23:28

J. M. Arnold

6,8674 gold badges29 silver badges51 bronze badges

answered May 22, 2021 at 20:11

krishna

513 bronze badges

Comments

user6266369 · Accepted Answer · 2018-07-03 15:23:26Z

3

This is a Bug in the Installer of 8.0.11. There are changes in the lower_case_table_names variable in the new release. See:

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

Nobody can fix this. If you installing the Server the configfile is write before new. Every time. So if you fix this 0.0 to 0 in my.ini the changes will be overwritten.

Somebody have to report a this bug to MySql.

EDIT: I have report a bug to oracle: https://bugs.mysql.com/bug.php?id=91539

edited Jul 3, 2018 at 15:23

answered Jul 3, 2018 at 15:15

user6266369

3163 silver badges17 bronze badges

2 Comments

user6266369 Over a year ago

I have report a bug to oracle:

avs099 Over a year ago

I experienced this issue, and was able to install v. 5.7.22.1 by doing the following: on configuration screen, when you get this error - do not click anything - open the my.ini, replace 0.0 with 1 (if you are on Windows) and, keeping the file open, click "Execute" again. That worked right away for me.

Abhijay Kumar · Accepted Answer · 2018-07-08 05:41:44Z

2

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

Abhijay Kumar

1,12811 silver badges22 bronze badges

Comments

Abdulwahid · Accepted Answer · 2018-07-19 11:59:06Z

1

Update the installer for mysql-installer-web-community-5.7.22.1 file during the installation from the web . I encountered the same problem, after updating the installer it works correctly.

edited Jul 19, 2018 at 11:59

answered Jul 19, 2018 at 10:49

Abdulwahid

3374 silver badges14 bronze badges

Comments

Yan · Accepted Answer · 2018-07-25 02:44:13Z

1

As the bug reported in https://bugs.mysql.com/bug.php?id=91476, upgrade MySQL installer to 1.4.26.0 and reinstall MySQL server would resolve the issue.

answered Jul 25, 2018 at 2:44

Yan

111 bronze badge

Comments

Elena · Accepted Answer · 2018-07-25 21:40:44Z

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:

uninstall all the related features with MySql( use Control Panel > Programs and Features)
go to C: drive, make all hidden files visible(view > hidden items), find ProgramData file
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.

Jithin Scaria · Accepted Answer · 2018-07-04 13:00:46Z

0

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.

edited Jul 4, 2018 at 13:00

Jithin Scaria

1,3191 gold badge16 silver badges27 bronze badges

answered Jul 4, 2018 at 12:11

elbee

1

Comments

Chandan · Accepted Answer · 2018-07-24 20:28:59Z

0

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

There is a folder MySQL Installer for Windows\Manifest\Templates
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

Chandan

1012 bronze badges

Comments

roschach · Accepted Answer · 2018-12-20 02:24:44Z

0

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

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

edited Dec 20, 2018 at 2:24

roschach

9,63617 gold badges92 silver badges141 bronze badges

answered Dec 19, 2018 at 23:01

Deven Chavda

11 bronze badge

Comments

Just me · Accepted Answer · 2025-01-10 11:51:22Z

0

I had the same issue configuring MySQL 9.1.0, then someone pointed out that he solved his problem just by updating Visual C++. So did I, and it worked for me! For those who understand Korean : https://www.inflearn.com/community/questions/1420270/sql-%EC%84%A4%EC%B9%98-%EB%AC%B8%EC%A0%9C?focusComment=378689 :)

answered Jan 10 at 11:51

Just me

1

1 Comment

Community Jan 13 at 8:00

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Kevin · Accepted Answer · 2022-12-30 11:01:07Z

-1

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.

answered Dec 30, 2022 at 11:01

Kevin

995 bronze badges

1 Comment

Luuk Over a year ago

see: Supported Platforms: MySQL Database

guneysus · Accepted Answer · 2023-10-10 13:10:50Z

-1

Uninstall all mySql from the machine. It can be simply done from the control panel. This might not solve the problem completely, so remove the mySql data from your machine. To do this, you need to delete from programdata folder. To access it press windows + r buttons and type %programdata% then press Enter. In there, you should find the mySql folder and delete it.

After completing above steps you completely deleted mySql 😀

You can now reinstall it

OTHER CASE

If this error occurs: installation missing VCRUNTIME140.dll and MSVCP140.dll missing in machine, then install it from this link, then run it again.

😀 Problem solved!

edited Oct 10, 2023 at 13:10

guneysus

6,5692 gold badges49 silver badges49 bronze badges

answered Jun 11, 2023 at 16:58

Chaitanya Nalam

11 bronze badge

Collectives™ on Stack Overflow

Error installing mysql

13 Answers 13

1 Comment

Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

1 Comment

OTHER CASE

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

13 Answers 13

1 Comment

Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

1 Comment

OTHER CASE

Comments

Your Answer

Sign up or log in

Post as a guest

Related