Restarted my pc and suddenly MySQL deactivated in xampp(lampp) on Linux 12.04 -
It was working fine for a long time, I do not remember that when I installed this Ubuntu on my PC So it was more
and I had a jump on linux setup (it is called lamp) and all were working fine, as long as I can not run mySQL since the last time I restart
When I try to go to the local host / phpmyadmin im getting error
# 2002 - Any such file or directory 'S server is not responding (or the local socket of the local server is not configured correctly).
When I check the localhost / XMPP under the situation, it says that
MySQL database is excluded
sudo / opt / lampp / lampp restart linux 1.8.3-2 ... XAMPP for XAMPP Restart: Preventing Apache ... okay. XAMPP: Preventing MySQL ... Not Running XAMPP: Preventing PROPPD ... OK XAMPP: Apache is starting ... OK XAMPP: MySQL is starting ... OK XAMPP: ProPhPPD is starting Is ... OK
but still when MySQL is not working I get a single response when I just start / stop mysql I It gets
sudo / opt / lampp / lampp startmysql XAMPP: Start MySQL ... okay. Sudo / opt / lampp / lampp startmysql XAMPP: Start MySQL ... OK Sudo / opt / lampp / lampp startmysql XAMPP: Start MySQL ... OK Sudo / opt / lampp / lampp stopmysql XAMPP: Stop MySQL ... no Running
I try to start it no matter how many times it does not matter that it will not start.
/etc/init.d/mysql or service mysql is not installed and it shouldn '
I tried this and this and other answers but no luck
I did not find any luck in the / opt / lamp folder, but there was no luck. I checked php.ini httpd mysql config and I do not see anything wrong, all users' permissions and passwords are correct.
So any help, what can be the problem, so it only stops the work when I did not touch anything Restart my PC.
My entire exit applications, unexpectedly shutting down my database and crashes mysql application < / P>
I found this and followed his solution.
In summary I did, in my.cnf, search for:
[mysqld]
for my case W / c / opt / lampp / etc /my.cnf and on the bottom, on a new line, put it:
< Code> innodb_force_recovery = 1
Then I OK
/ opt / lampp / lampp / stop
and then
/ opt / lamp P / lampp / start
Then I check using
/ opt / lampp / lampp / status
Then I returned the innodb_force_recovery value from 1 to 0 .
Comments
Post a Comment