MySQL 5.5 won't install on Ubuntu 14.04 server

dakoris73 · 03-22-2015, 03:19 AM

Hello everyone,

I've been trying now for a week to try and get a LAMP setup on my Ubuntu 14.04 32bit server, and have not been able to get this to finish installing. I've removed, purged, cleaned, and reinstalled this process many many times and still can't seem to get the MYSQL server to start or finish installing, and I've read too many posts about how other's were able to fix their installs, but yet, I still have my problem.... I put in my root password, but it won't take and errors out, regardless of what I do.......

here's the error after I run the 'apt-get install mysql-server'

Code:

start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
Processing triggers for ureadahead (0.100.0-16) ...
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Here's what my log file shows:

Code:

150322 03:05:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150322  3:05:52 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
150322  3:05:52 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150322  3:05:52 [Note] Plugin 'FEDERATED' is disabled.
150322  3:05:52 InnoDB: The InnoDB memory heap is disabled
150322  3:05:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150322  3:05:52 InnoDB: Compressed tables use zlib 1.2.8
150322  3:05:52 InnoDB: Using Linux native AIO
^G/usr/sbin/mysqld: Can't create/write to file '/tmp/ib5ZyT8X' (Errcode: 13)
150322  3:05:52  InnoDB: Error: unable to create temporary file; errno: 13
150322  3:05:52 [ERROR] Plugin 'InnoDB' init function returned error.
150322  3:05:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150322  3:05:52 [ERROR] Unknown/unsupported storage engine: InnoDB
150322  3:05:52 [ERROR] Aborting

150322  3:05:52 [Note] /usr/sbin/mysqld: Shutdown complete

and here's what the commands I've tried to remove this BEFORE I tried the next install:

Code:

apt-get remove --purge mysql-server
apt-get remove --purge mysql*
rm -rf /etc/mysql*
rm -rf /var/log/mysql*
rm -rf /var/lib/mysql*
dpkg --purge mysql-server 
dpkg --purge mysql-common
dpkg -selections | grep mysql   (to confirm uninstallation)

and yet, when I go to install it again, I get the same errors...... and I have no idea what or where to go at this point......

Hopefully someone can help me get past this so that I can get this installed and onto getting my LAMP server running....

Thanks......

dakoris73 · 03-22-2015, 03:22 AM

Also, forgot to add that I did try the "NEW" codings for the updated "key-buffer-settings" and "myisam-recover-options" and I still get these same errors....... regardless of what I do, It wont let me put in a root password, gives me an error saying that it can't complete, and then the same errors........

GGGGGGRRRRRRRRRRR.....................

yancek · 03-22-2015, 08:45 AM

I installed LAMP on Ubuntu last month and the command I used to install mysql was:

Quote:

sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql

The install starts and then a window shows asking to set mysql root pasword, do this, repeat passwd. When that finishes, to activate mysql:

Quote:

sudo mysql_install_db

Next run setup script: sudo /usr/bin/mysql_secure_installation

Did you see an option to set a root password for mysql during the installation? That has to be done as the mysql root password is not the same as your system root password although it can be. Before you can use it in mysql, you do need to set it. Given the errors showing from your post it looks like there might be other problems.

dakoris73 · 03-23-2015, 09:21 PM

I did see the option to add the root password, which I filled in, and it still tells me that I can't use that password cause I already have a password there, or that the service didn't start..... and I'm leaning more towards the server not starting at this time...... and thats where it comes up with that top error in my first post.......

I've deleted, wiped, removed, and cleaned up every last little bit of MySql that I can find on this server, and yet I still can't seem to get a clean install of this to work.

yancek · 03-24-2015, 08:30 AM

Quote:

I did see the option to add the root password, which I filled in, and it still tells me that I can't use that password cause I already have a password there,

If you had previously set a password for mysql, then you should just hit the Enter key, leave it blank. You may be having these problems because of multiple attempts to install. I don't use Ubuntu regularly so I'm not sure how you would get rid of anything related to mysql. The options you have noted are all I'm aware of. Good luck with it.

Habitual · 03-24-2015, 11:13 AM

Quote:

Originally Posted by dakoris73

I've deleted, wiped, removed, and cleaned up every last little bit of MySql that I can find on this server, and yet I still can't seem to get a clean install of this to work.

n/m. Sorry.

Habitual · 03-24-2015, 11:25 AM

Quote:

Originally Posted by dakoris73

Here's what my log file shows:

Code:

...
150322  3:05:52 [ERROR] Plugin 'InnoDB' init function returned error.
150322  3:05:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150322  3:05:52 [ERROR] Unknown/unsupported storage engine: InnoDB
150322  3:05:52 [ERROR] Aborting

150322  3:05:52 [Note] /usr/sbin/mysqld: Shutdown complete

Try this ? http://www.debian-tutorials.com/how-...-engine-innodb