Wordpress mysql problem - Error establishing a database connection

January 27, 2014 12.2k

By:

rhombusone

Hi there, I've recently got the $10/m package and I've got two sites running off the server. A static jekyll site, and a wordpress website. I had both running really nicely, however, this morning I found: Error establishing a database connection when visiting the wordpress site. I ran `free -m` to see how much memory I had left and I could see there was only like 96mb left. Can anyone help me figure out how it'd suddenly stop working and drain all the memory, and why, even after a restart I still can't access the site. What can I do to fix and avoid this problem in the future. Do you recommend a higher package to run a wordpress website? Thanks in advance

2 comments

hitchcockwill September 28, 2015
I'm having this same issue now. Have you continued to have this problem since your original posting?
nathanjameshill October 1, 2015
I am also having this issue:-( Any idea how to fix? The only way I have found to fix the issue is to reset db security for the user account.

Log In to Comment

7 Answers

TiagoMia April 11, 2014

I did run the mysqld and it worked:



sudo mysqld

I'm not so into it -- a friend helped me with that.

AbhishekGhosh August 30, 2015

You should get a Nobel prize!
I am not new user! I forgot to run the command & was fighting with my.cnf's all possible issues! Yeah, actually both mariadb & mysql need a kick. Thanks a lot.

pablo January 27, 2014

You need to add swap: How To Add Swap on Ubuntu 12.04. WordPress is also best optimized with Nginx and caching. So, it's advisable to check out (i) memcache; (ii) APC; (iii) varnish; and (iv) the W3 Total Cache plugin -- in addition to switching to Nginx.

How To Add Swap on Ubuntu 12.04

by Etel Sverdlov

Linux swaps allow a system to harness more memory than was originally physically available. Here's how to set up a linux swap file on Ubuntu 12.04

ibrahimmumcu April 6, 2014

I already swapped but nothing has changed. Still got this error!

TiagoMia April 11, 2014

@Ibranhim, did you manage to fix it? we got the same problem here with an wordpress installation.. :/

kamaln7 MOD April 11, 2014

@Tiago: Running mysqld manually isn't recommended. Use this command instead:

sudo service mysql start

nhatkhoa April 21, 2014

i've solve the same problem with "rror establishing a database connection" ( Not Enough RAM ) by added Swap, tune SQL, Apache ...

Read this post for more detail :

http://digitaloceanvps.blogspot.com/2014/04/best-configuration-for-512mb-1gb-ram.html

LFRed January 23, 2016

I have the same problem and tried a number of suggestions, including upgrading to a 1GB droplet, adding a swap file etc.. same problem.

I ended up creating an account here , transferred a copy of my site and it cleared up the problem, improved the performance dramatically and provided us with 24/7 support. This is one of those things where you get what you pay for.

Have another answer? Share your knowledge.