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

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

eclipse plugin - Run java code error: Workspace is closed -

c - Error on building source code in VC 6 -