So today I installed MariaDB so I can login through phpmyadmin, apparently it didn't work so I removed it, tried again like four times and I failed. Decided to go with MySQL Server instead. I couldn't install it after removing MariaDB.

Here's what I'm trying to do and the outputs:

shavit@dedi:~$ sudo apt-get install mysql-server

[sudo] password for shavit:

Reading package lists... Done

Building dependency tree

Reading state information... Done

mysql-server is already the newest version (5.7.12-0ubuntu1).

0 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade.

2 not fully installed or removed.

After this operation, 0 B of additional disk space will be used.

Do you want to continue? [Y/n] y

Setting up mysql-server-5.7 (5.7.12-0ubuntu1) ...

mysql_upgrade: Got error: 1524: Plugin 'unix_socket' is not loaded while connect                                                                                                                                                             ing to the MySQL server

Upgrade process encountered error and will not continue.

mysql_upgrade failed with exit status 11

dpkg: error processing package mysql-server-5.7 (--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.7; however:

  Package mysql-server-5.7 is not configured yet.



dpkg: error processing package mysql-server (--configure):

 dependency problems - leaving unconfigured

No apport report written because the error message indicates it's a follow-up er                                                                                                                                                             ror from a previous failure.

                            Errors were encountered while processing:

 mysql-server-5.7

 mysql-server

E: Sub-process /usr/bin/dpkg returned an error code (1)



shavit@dedi:~$ sudo apt-get remove mysql-server

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following packages were automatically installed and are no longer required:

  libaio1 mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7

  mysql-server-core-5.7

Use 'sudo apt autoremove' to remove them.

The following packages will be REMOVED

  mysql-server

0 to upgrade, 0 to newly install, 1 to remove and 0 not to upgrade.

2 not fully installed or removed.

After this operation, 159 kB disk space will be freed.

Do you want to continue? [Y/n] y

(Reading database ... 35749 files and directories currently installed.)

Removing mysql-server (5.7.12-0ubuntu1) ...

Setting up mysql-server-5.7 (5.7.12-0ubuntu1) ...

mysql_upgrade: Got error: 1524: Plugin 'unix_socket' is not loaded while connecting to the MySQL server

Upgrade process encountered error and will not continue.

mysql_upgrade failed with exit status 11

dpkg: error processing package mysql-server-5.7 (--configure):

 subprocess installed post-installation script returned error exit status 1

Errors were encountered while processing:

 mysql-server-5.7

E: Sub-process /usr/bin/dpkg returned an error code (1)

I'm really lost right now.. Googling told me I should run apt-get install -f but that's what I get:

shavit@dedi:~$ sudo apt-get install -f

Reading package lists... Done

Building dependency tree

Reading state information... Done

0 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade.

2 not fully installed or removed.

After this operation, 0 B of additional disk space will be used.

Setting up mysql-server-5.7 (5.7.12-0ubuntu1) ...

mysql_upgrade: Got error: 1524: Plugin 'unix_socket' is not loaded while connecting to the MySQL server

Upgrade process encountered error and will not continue.

mysql_upgrade failed with exit status 11

No apport report written because the error message indicates it's a follow-up error from a previous failure.

                                                                                                            dpkg: error processing package mysql-server-5.7 (--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.7; however:

  Package mysql-server-5.7 is not configured yet.



dpkg: error processing package mysql-server (--configure):

 dependency problems - leaving unconfigured

Errors were encountered while processing:

 mysql-server-5.7

 mysql-server

E: Sub-process /usr/bin/dpkg returned an error code (1)

So I ran sudo apt-get autoremove and proceed to install again:

dpkg: error processing package mysql-server (--configure):

 dependency problems - leaving unconfigured

Processing triggers for libc-bin (2.23-0ubuntu3) ...

No apport report written because the error message indicates it's a follow-up error from a previous failure.

                            Errors were encountered while processing:

 mysql-server-5.7

 mysql-server

E: Sub-process /usr/bin/dpkg returned an error code (1)

I'm a newbie with anything related to Linux and especially Ubuntu.
Could anyone lend their hand and help me? Much appreciated!