If like me you had installed a MySQL on your server (Windows 2012), and when reinstalling the installer is unable to start the MySQL service. Select MySqlInstanceConfig.exe and double-click on it and select default configuration or do the regular set up that we do when installing MySql server first time. C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\MySqlInstanceConfig.exe.bak format files which cause for the instance config.exe un-responding. Go to C:\Program Files (x86)\MySQL\MySQL Server 5.5ĭelete the selected files my.ini and and other. After deleted selected files from C:/ProgramData/MySQL/MySQL Server 5.5/Data/.(why because to create new MySql instance or when reconfiguring MySql service by clicking on MySqlInstanceConfig.exe and selecting default configure, after enter choosing password and clicking on execute the wizard will try to create these log files or will try to append the text again to these log files and other files which will make the setup wizard as unresponding and finally end up with configuration not done). It contains all tables data and log info, ib data, user.err,user.pid. Now go to C:\Program Files (x86)\MySQL\MySQL Server 5.5īasedir="C:/Program Files (x86)/MySQL/MySQL Server 5.5/"ĭatadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"Ĭhoose data dir Go to "C:/ProgramData/MySQL/MySQL Server 5.5/Data/".See in the Service list (refresh F5) where MySql service should not be found. Then select remove instance and click on next to remove non-working MySql service instance. Go to installed folder MySql, double-click on instance configĬ:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\MySqlInstanceConfig.exe.Keep open the following wizards and folders:Ĭ:\Program Files (x86)\MySQL\MySQL Server 5.5\binĬ:\Program Files (x86)\MySQL\MySQL Server 5.5 This error will be thrown when unexpectedly MySql service is stopped or disabledįirst try restart PC and MySql Service couple of times ,if still getting same error then follow the steps. Manual backup: Go to datadir path (see in my.ini file) and copy all databases.sql files from data folder Keep dump/backup of all databases.This is not 100% reliable process. Under most circumstances this is fine, but if you want to use the NetworkService account (which is what the installer creates the service as) you can change it using the Services administrative tool. This creates a service that runs as the LocalService account which presents anonymous credentials on the network however. mysqld -install-manual "service_name" -local-service -defaults-file="C:\path\to\mysql\my.ini" You can use -install to create a service that starts with the system automatically, or -install-manual to create a service that requires you to start it. Start by removing the old service: mysqld -remove "service_name" If you don't want to reinstall the server however, you will have to recreate the service. After installation, if you so choose, the display name can safely be changed to use spaces and other characters by using: sc config MySQL56 DisplayName= "MySQL 5.6" ![]() The name that I had originally specified was for a display name, when it should have been a simple service name. The installer uses the same value for the service name and service display name. The first is to simply reinstall MySQL Server 5.6 using the default, no-space service name MySQL56. There are two ways to fix the problem (all commands should be run from an elevated command prompt). ![]() ![]() It seems that the MySQL Installer (and MySQL Notifier) does not put the name in quotes which causes it to use an incorrect service name later on. While it is technically valid, you should not do that. When I had this issue, it was because I used a space in the service name during installation. There could be clues as to what is going wrong, which may be different than this scenario. You should start by checking the error log and/or the startup message log when managing the instance using MySQL Workbench.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |