digital ocean Linux MySQL Ubuntu 🏴‍☠️

เมื่อ Mysql Restart ไม่ได้ บน Digital Ocean

Swap Memory

The tiny droplet I have has 512MB RAM, and 20GB on SSD harddisk.
It’s a waste not to create swap memory out of the 20GB SSD!
So, add a few GB of swap memory to your Ubuntu.


# Confirm you have no swap
sudo swapon -s

# Allocate 1GB (or more if you wish) in /swapfile
sudo fallocate -l 1G /swapfile

# Make it secure
sudo chmod 600 /swapfile
ls -lh /swapfile

# Activate it
sudo mkswap /swapfile
sudo swapon /swapfile

# Confirm again there’s indeed more memory now
free -m
sudo swapon -s

# Configure fstab to use swap when instance restart
sudo nano /etc/fstab

# Add this line to /etc/fstab, save and exit
/swapfile none swap sw 0 0

# Change swappiness to 10, so that swap is used only when 10% RAM is unused
# The default is too high at 60
echo 10 | sudo tee /proc/sys/vm/swappiness
echo vm.swappiness = 10 | sudo tee -a /etc/sysctl.conf


MySQL 🏴‍☠️

MySql: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111)

Tried several ways and finally solved it through the following way

sudo gksu gedit /etc/mysql/my.cnf

#bind-address =


bind-address = localhost

if your MySQL server IP is then entire block should be look like as follows:
bind-address =

and restarted

sudo /etc/init.d/mysql restart
it worked

Rev :