Re: Installing My SQL but not at the default locations
Posted by: Jose Ramirez
Date: October 09, 2022 11:50AM

Hi Anand,
By default, the server is installed as a windows service with name MySQL80, did you keep this configuration or did you uncheck the "Configure MySQL Server as a Windows Service" checkbox during configuration?

If MySQL Server was installed as a service the MySQL80 Windows service is executed automatically and there is no need to manually run the "mysqld" command since the server will already be running. If you unchecked the mentioned checkbox a mysqld process was started instead (which needs to be manually started if you later restart your machine).

The error you mentioned in your original message is most likely being shown because mysqld is already running, you are attempting to run mysqld without opening the cmd with admin privileges or because you need to provide some parameters such as specifying the location of the my.ini file which contains the settings for the server. If no other mysqld process is currently running you should be able to start the server with the following steps:

1. Open cmd window as an admin.
2. Navigate to the folder where the mysqld.exe is located.
3. Run command: mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console

Hope this helps.

Jose Ramirez
MySQL on Windows Team

Options: ReplyQuote

Written By
Re: Installing My SQL but not at the default locations
October 09, 2022 11:50AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.