How can I make MySQL server in XAMPP work well after a crash?
The MySQL server in XAMPP does not start well anymore.
I tried changing the port as recommended here, and the server still does not start, although it attempts to do this: a new PID is shown for a fraction of second next to MySQL in the context of the screenshot below when clicking on Start.
I also tried to run netstat -ano|find "3306" (I tried with 3307 too) but it does not show anything, the same when running it in the Command Prompt as admin. I also restarted the computer and removed the new PHP code I wrote today. Yesterday everything worked fine.
Note: the day before yesterday I had my working computer instantly turned off by mistake.
A screenshot:
The log file is here and a part of it says that it is a bug, but a bug of MariaDB which I do not use.
I am a beginner, and I use MySQL just for WordPress.
Running netstat -ab results in this.
Now I am checking if there are updates to XAMPP.
It seems that there are no updates to XAMPP.
First of all check your port and check if your firewall is not blocking that port, try different ports 3306, 3307, 3308.
This is your error:
2020-02-20 9:40:14 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-02-20 9:40:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-20 9:40:14 0 [Note] Server socket created on IP: '::'.
I would re-install xampp instead of spending tons of time on trying to find error.
There are some explanition here : https://forums.mysql.com/read.php?10,652134,652135#msg-652135
Open shell from from control panel and start mysql with this command:
mysqld –-console –-skip-grant-tables –-skip-external-locking
Open another shell from control panel and repair database with this command:
mysqlcheck -r --databases mysql --use-frm
Stop mysql, close shells and restart mysql normally.
Also see InnoDB Corruption and Recovery https://chepri.com/mysql-innodb-corruption-and-recovery/
- How to avoid empty elements by splitting a string on one or more consecutive spaces?
- How to split a multiline string on newlines?
- Hiw to limit the number of elements produced by explode()?
- Explode string only once on first occurring newline character
- Split a string only on the first of its multiple delimiters to produce a 2-element array
- How to Resolve the Update function for single view page laravel -11 crud
- Reformat a string with two sets of delimiters into more human-readable, multiline text
- How to make all array keys the same as their respective value?
- Auth guard [:api] is not defined?
- Create an array of each character and its following character from an input string
- How to reindex an array after extracted from a larger array?
- Isolate a column of values from an array of objects
- Use an array of words to match and an array of replacements to perform replacements on a string
- Calculate a new column and remove other columns within nested objects of a multidimensional object
- Woocommerce mini-cart.php doesnt override the template
- PECL/Memcache and PECL/Memcached
- Parse an array of delimited values into a flat, associative array
- Parse a text file into an array of associative arrays by splitting on semicolons then by equals signs
- How to access a deeply nested value in a multidimensional array?
- Can variables declared inside of a function's scope be accessed in the global scope?
- Loop only retains last item iterated
- How to access the second level values of a 2d array?
- How can I crawl a page for data as if it's logged in if I have the login credentials?
- Run function controller when date expired
- How to echo XML file in PHP
- Handling Exceptions inside Pipeline
- CodeIgniter 4 Error stating SetScheme requires string but null given. Even though already passing a string
- Use the symfony/mailer component without the symfony framework
- rewrite my url using htaccess
- Can't start Laravel, I get "Base table or view not found" error