XAMPP MySQL NOT working after modifying WordPress site URL
-
Hello everybody
I been creating a website using WordPress Elementor Pro during the last two months, and I been using XAMPP Control Panel v3.3.0 (Apache & mysql) since the beginning)
only had couple issues that I don’t consider that important, except for one two days ago.The thing is that I was getting some messages while login into WordPress (https://localhost/wordpress-6.3/wordpress/wp-login) saying that the URL was NOT secure, then
I had the idea of getting a CSR for SSL, etc. but before doing that I said to myself, maybe I should partially change (modify) the “site URL” (NOT WordPress URL) and I went to
the WordPress … panel/settings and modified the URL this way … form: “https://localhost/wordpress-6.3/wordpress” … to: “https://localhost/wordpress-63/wordpress” saved and logout from WordPress and restarted XAMPP … and since that moment mysql is NOT coming-up … always generating the following in XAMPP console …3:39:05 PM [mysql] Status change detected: running
3:39:07 PM [mysql] Status change detected: stopped
3:39:07 PM [mysql] Error: MySQL shutdown unexpectedly.
3:39:07 PM [mysql] This may be due to a blocked port, missing dependencies,
3:39:07 PM [mysql] improper privileges, a crash, or a shutdown by another method.
3:39:07 PM [mysql] Press the Logs button to view error logs and check
3:39:07 PM [mysql] the Windows Event Viewer for more clues
3:39:07 PM [mysql] If you need more help, copy and post this 3:39:07 PM [mysql] entire log window on the forumsI tried multiple things after reading different opinion even in WordPress library, like possible problems with … the port, firewall, etc. and any of those seems the root problem.
After coming to this site, I found the following recommendation in order to obtain more information about the problem … and I did run from XAMPP shell
mysqld –defaults-file=mysqlbinmy.ini –standalone –console
I obtained a really long result (a bunch of information), which I believe that an expert in your side could understand, decipher and recommend a solution.
The log result after running the last command is really long so not sure if should copy it here, but in any event seems in my opinion that something is NOT allowing mysql write due to a conflict with site URL
Please, let me know if I should upload a copy of the log and/or if there a way to obtain more precise information for a solution.
I am really behind in finishing my website project, and I am stuck now!I read that seems like that none of you use remote services to help, but I do have the Zoom utility where I can create a session and opened (share) to someone who may be able to help me.
Thank you in advance!
-
Hello All,
I am having the same problem. I am using Elementor Free version and was editing one of my pages and then mysql in XAMPP control panel stopped running. I tried starting it again but got the following message:
4:34:27 PM [mysql] Status change detected: stopped 4:34:27 PM [mysql] Error: MySQL shutdown unexpectedly. 4:34:27 PM [mysql] This may be due to a blocked port, missing dependencies, 4:34:27 PM [mysql] improper privileges, a crash, or a shutdown by another method. 4:34:27 PM [mysql] Press the Logs button to view error logs and check 4:34:27 PM [mysql] the Windows Event Viewer for more clues 4:34:27 PM [mysql] If you need more help, copy and post this 4:34:27 PM [mysql] entire log window on the forumsI believe one of the tables is corrupted but can’t verify that because I can’t login to the mysql server through the MySQL shell and follow the instructions to diagnose and repair a table. Here is the error I get when trying to login to mysql through the shell.
# mysql --user=root --password= ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (10061)Any assistance or resources would be helpful. For example, some way to verify the database is corrupted.
- The topic ‘XAMPP MySQL NOT working after modifying WordPress site URL’ is closed to new replies.
WordPress.com Forums 