Hi, I currenty have a LAMP, running on Centos, everything was fine, but my MYSQL is not working.
When i try to connect via
mysql -u root -p
I get the error:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)
Note: This error has been occur, when i will install WordPress theme on my Site, after this, i will click on the Import Demo Button to import the FrontPage, then error occur.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
The error message means that mysql process has crashed for some reason please share your mysql error log by giving as the output of this command
tail -20 /var/log/mysql/error.log
My guess is that your droplet is running out of memory how much memory did you allocate for it?
Hope this helps.
lsof -i:3306 kill the running process with kill -9 PID then restart the mysql service
Dear, When i will enter this command on PuTTy, i get an error tail: cannot open ‘/var/log/mysql/error.log’ for reading: No such file or directory Note: I have 512 MB Ram Server with lot of Bandwidth Available. I Will Deploy Server and Start Installing WordPress, everything was fine, but when i will try to install theme, after this it shows an database error.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.