Mysql command line window does not open

]2I installled mysql I thought successfully, but when I try to open the command line client for i, it opens for a split second then closes, as with other people on Stack Overflow.

When going to Task Manager > Services tab and trying to start Mysql, I get the error with “Access denied”. So I followed up with someone's advice to go to Control Panel/Admin Tools and try to start Mysql there. I get the following error window!

Services (on title bar)
“The mysql service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.”

OK button bottom right.

Sorry I could not paste the error window here!

I wonder what the solution would be now.

Thanks in advance,
M

3 Answers
3

Now there are couple of steps you have to follow. As there seems a installation or configuration error.

Firstly remove MySQL from your device fully. Uninstall from control panel. Delete files from drive where it made a folder while installing.

Reinstall MySQL from very beginning.

There are other options using regedit tooling and stuffs also.

Other problem with it I can feel is some other process is not letting it executed. So you can kill the process using command prompt and then start it again.

But for now I would recommend just reinstall it and do nothing parallel while installing it. After installation just restart your device and it'll work for sure.

Still if you have trouble I'm here for sure.

FOR THE BENEFIT OF OTHERS:

I tried to delete all files in Mysql folders and uninstalled all mysql programs (except Connector .NET which was not possible) then tried to reinstall mysql.

I m actually getting an error during the configuration of Mysql Server (screenshot below) - ALL other steps were configured correctly, o it is defo this step that is causing the error.

I also tried very briefly stopping my Firewall, but that did not help either.

The below is the info in the configuration log file, if it makes sense to anyone.

Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

Beginning configuration step: Updating firewall
Adding firewall rule for MySQL80 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall

Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]

Beginning configuration step: Initializing Database [if necessary]
Deleting Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: C:Program FilesMySQLMySQL Server 8.0binmysqld.exe --defaults-file="C:ProgramDataMySQLMySQL Server 8.0my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:Program FilesMySQLMySQL Server 8.0binmysqld.exe --defaults-file="C:ProgramDataMySQLMySQL Server 8.0my.ini" --initialize-insecure=on --console
2018-09-10T19:31:39.510737Z 0 [ERROR] [MY-011071] [Server] Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0')
2018-09-10T19:31:39.510737Z 0 [ERROR] [MY-011071] [Server] C:Program FilesMySQLMySQL Server 8.0binmysqld.exe: Error while setting value '0.0' to 'lower_case_table_names'
2018-09-10T19:31:39.526337Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-09-10T19:31:39.526337Z 0 [Note] [MY-010120] [Server] Binlog end
The attempt to initialize the database Failed
Ended configuration step: Initializing Database [if necessary]

Beginning configuration step: Starting Server
Starting MySQL as a service

It would be helpful if you able to put any screenshot or video recording. As your error seems to be solvable but without exact understanding, it would be just an assumption.
Once you share it I'll surely able to solve your error.

INFO COPIED FROM Log Tab in above window:- Beginning configuration step: Writing configuration file Ended configuration step: Writing configuration file
Beginning configuration step: Updating Windows Firewall rules Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306
Deleted 1 rule(s). Ok.
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. 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 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... 2019-01-17T21:00:17.450875Z 0 [ERROR] [MY-011071] [Server] Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0') 2019-01-17T21:00:17.450926Z 0 [ERROR] [MY-011071] [Server] C:Program FilesMySQLMySQL Server 8.0binmysqld.exe: Error while setting value '0.0' to 'lower_case_table_names' 2019-01-17T21:00:17.451367Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-01-17T21:00:17.451477Z 0 [Note] [MY-010120] [Server] Binlog end Process for mysqld, with ID 9456, 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

Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.