Dtyjlui

I finally fixed it by running sudo /etc/init.d/mysql start. I just had to insert sudo in front of the command.

try this:

sudo service mysql stop

sudo service mysql start

In my case the error resulted of changing the ip address on the server.

cat /var/log/mysql/error.log



150427 23:01:08 InnoDB: 5.5.43 started; log sequence number 11731761

150427 23:01:08 [Note] Server hostname (bind-address): '192.168.1.234'; port: 3306

150427 23:01:08 [Note]   - '192.168.1.234' resolves to '192.168.1.234';

150427 23:01:08 [Note] Server socket created on IP: '192.168.1.234'.

150427 23:01:08 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address

150427 23:01:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?

150427 23:01:08 [ERROR] Aborting

changing the

 bind-address       

in

 /etc/mysql/my.cnf

to the current ip
and restarting the server

sudo /etc/init.d/mysql start

solved the problem

I have faced same issue, in my case there is another mysql service was running

$ ps -aux | grep mysql

mysql     7241  0.0  5.1 562600 52812 ?        Ssl  13:36   0:02 /usr/sbin/mysql

ubuntu   13580  0.0  0.0  10468   916 pts/0    S+   15:50   0:00 grep --color=au



$ sudo kill  7241

Then I started mysql.

$ sudo /etc/init.d/mysql start

* Starting MySQL database server mysqld                                 [ OK ]

There are two possible problems with Mysql package:

1. 
   

   Really a space problem:

   
   
   

   Many distributions have their /var directory in the original root partition which is not made big enough by default to hold real-life data. They usually create separate partition for /usr with tons of space

   
   
   

   Check this and you will get full details and your answer

   
   
   

   https://serverfault.com/questions/256729/error-the-partition-with-var-lib-mysql-is-too-full

   
   


2. 
   

   It is a bug which might not have been fixed and to fix it follow this article:

   
   
   

   https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/118523

   
   

In the partition /var there are several directories that accumulate many files which can fill up the partition.

In my case logs are saved in /var/logs filling up /var prevented me from starting mysql.

I deleted some of those old logs and that solved my problem. If you do not have log rotation it is better that you try acerlo since if you do not have this process the logs can add up to many GB in a single file.

In my case none of the above helped, the problem was that /var was really full:

$ df -h

...

/dev/sda3       2.7G  2.7G     0 100% /var

So I just used ncdu to check what was taking so much space:

sudo ncdu /var

Delete some useless stuff with d, restarted

sudo systemctl restart mysql.service

And voilà, everything working now.

Run the command sudo apt-get --reinstall install mysql-server to re-install MySQL. It will re-create the missing directories and allow you to start the server again.