![]() I too had this problem, its easy to solve: If it's still not working, than delete that my.ini you just copied from C:\Windows and start the service from the command line once again. If it doesn't display any error, than the service startup was successfull. "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" -verbose Try to start the service again from the command line : Goto C:\ProgramData\MySQL and copy the file named my.ini to C:\Windows\ If you've still got no luck, this is how I did it : If you can figure out what's missing from what's in that log, then good, you're done. If it fails to create data for some reason, do it manually under that directory and try again. It should fail and put the error log in a directory named data under C:\Program Files\MySQL\MysSQL Server 5.7\. run "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" -verbose.open the command line as an administrator :. ![]() If it fails to restart, then you can follow these steps : "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" -install ![]() First make sure it is installed as a windows service : Run.I was able to get into MySQL community server from cmd and I can use XAMPP server as well.įrom what I've gathered this means the mysql service (mysqld) isn't running. Now everything seems to be working fine for me. Open XAMPP and change the port other than 3306 in two files.Click on reconfigure button in front of MySql server.Click Start and open MySql installer - community.Note: Stop the XAMPP server before following the steps. Step 2: Reconfigure XAMPP to use a different port other than 3306 Step 1: Reconfigure MySQL server to port 3306 If anyone had this same issue this is how I fixed it. So basically I had 2 MySQL servers installed in my system. It was because I changed my port during the installation of MySQL community server as I had XAMPP server installed and running as well which was not allowing me to use the port 3306. I got this error in command prompt when I tried to open MySQL from cmd "mysql -u root -p"Ĭan't connect to MySQL server on 'localhost:3306' (10061) Check the MySql in the windows service, And if it is not running, Start it by clicking on the service.Į. cd to C:\Program Files (x86)\MySQL\MySQL Server 5.6\binĬ:\Program Files (x86)\MySQL\MySQL Server 5.6\bin>mysqld.exe -installĭ. If MYSQL service is not present in windows service then follow below setups.ī. Once started the left pane will now give you the option to stop, pause and restart the service and you will now be able to connect to your MySql from the windows cmd line. Click this and a dialogue should appear to indicate Windows is attempting to start the service. When you select MySql you should see an option in the left pane that says 'Start the service'. Select the 'Services' option with the cogs next to it (not the executable file) and the below window will appear. You can find the services window by navigating to windows Start menu and typing 'services' in the search bar. If it is there and not running then start it. I also faced the same issue and resolved it by below setups:Ĭheck the MYSQL service in the windows service.
0 Comments
Leave a Reply. |