![]() ![]() Remember to save the hashed version of any and all passwords you create as we will use this next! -I opened a notepad and saved (and numbered) them. This is easily remedied by going to the "user accounts" tab in phpmyadmin, clicking on "edit privileges" and entering password. Now, open your browser and you should see the xampp page when you type in "localhost."Īdditionally, if this is your first time using xampp, you may see a warning about your lack of password (highlighted in pink) on your localhost/phpmyadmin/ page. Next, on your XAMPP control panel, click "config < my.ini" and change lines 19 and 27 (should have port = 3306) from "3306" to "3307."Īlso, you will need to navigate to xampp < phpMyAdmin < config.inc and change line 27, which should like something like this: Then check the box that says "Use port 80 and 443 for additional incoming connections." Save, close, and quit skype. Note that the computer I tested this on, also had skype).įirst logon to skype and navigate to "Tools < Options < Advanced < Connection." I am new to XAMPP, but I find that a combination of these suggestions works best (At least on Windows 8.1 with the latest version of XAMPP. Save it as anything.bat and run it everytime you want to use mysql. ) do if "%%a"="UDP" (taskkill /F /PID %%b) else (taskkill /f /PID %%c) You can simply use the following batch script to terminate the process automatically and enjoy :) off Then you can try starting mysql and it will work.Īnd now if you are lazy to do this step all over again when restarting the computer, ![]() Then simply open a command prompt as administrator and type taskkill /F /PID 1234 Then look for the address with port number 3306Īnd find out the PID corresponding to that. So to find out which process is using port 3306, open command prompt, and type netstat -n -o -a So the best way would be to find out which process is using port 3306, and then terminate the process. ![]() Secondly, uninstalling xampp might not do you any good because the process using the port 3306 (Mysql's default port) will still be running somewhere on your system. Well first thing, I know its late so I dont know if anyone will upvote it but oh well its okay, That is just a part of the log, the full one is a bit too big. InnoDB: Reading tablespace information from the. InnoDB: the log sequence number in the ib_logfiles!ġ30302 1:51:12 InnoDB: Database was not shut down normally! InnoDB: The log sequence number in ibdata files does not match I have reinstalled XAMPP for some reason and MySQL is not working, giving the following error in the console: 01:56:03 Error: MySQL shutdown unexpectedly.Ġ1:56:03 This may be due to a blocked port, missing dependencies,Ġ1:56:03 improper privileges, a crash, or a shutdown by another method.Ġ1:56:03 Check the "/xampp/mysql/data/mysql_error.log" fileĠ1:56:03 and the Windows Event Viewer for more clues
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |