How to Fix MySQL Database error : Can’t create database ‘newdbname’ (errno: 28)

Symptoms:
When i run the command to create new database on mysql, it was returned with below error message. How to fix this?

mysql> CREATE DATABASE newdbname;
ERROR 1006 (HY000): Can't create database 'newdbname' (errno: 28)

Findings and Solutions :
This error means that your mysql server does not have enough free space. You need to check the file system size and please remove unwanted software(s) or installers or files. What we suggest is please try to remove the files in /tmp first before you proceed to remove other files of software’s. Or maybe you can ask the system administrator to increase the partition size.

[root@server ~]# cd /tmp
[root@server ~]# rm -rf *

Restart mysql server:

[root@server ~]# service mysqld restart

Please re-run the below command:

mysql> CREATE DATABASE newdbname;
Query OK, 1 row affected (0.00 sec)