Ubuntu – Mysql Installation Problems with 18.04

18.04aptMySQLserversoftware installation

I installed a fresh copy of 18.04 am installing all the packages that are required. When installing mysql-server and mysql-client I receive the following error

dpkg: error processing package mysql-server-5.7 (--configure):
 installed mysql-server-5.7 package post-installation script subprocess 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 its a followup error from a previous failure.
                                                                                                          Processing triggers for libc-bin (2.27-3ubuntu1) ...
Processing triggers for ureadahead (0.100.0-20) ...
Processing triggers for systemd (237-3ubuntu10) ...
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

I have tried the purge, autoremove, autoclean, dist-upgrade routine but it does not work for me.

How do I fix this problem, please help

Best Answer

I solved this problem by going to Oracles mysql documentation on MySQL APT Repository which was a huge help, following all the instructions on the page allowed me to install mysql successfully.

What I did:

Download the mysql-apt-conf tool from http://dev.mysql.com/downloads/repo/apt/
Install the package using sudo dpkg -i /PATH/version-specific-package-name.deb
When installing select MySQL Server & Cluster to whatever you want by pressing enter and selecting one of mysql-5.7 or mysql-8.0 then go to Ok and press enter
Then sudo apt-get update(this step is required only for Ubuntu 17.10 or below)
Run sudo apt install mysql-server
After the main packages are installed run mysql_secure_installation, this will configure the password and other security stuff for mysql

Update

If anyone ran or had to run mysql_secure_installation withsudo, please note that you might not be able to login into mysql unless you use sudo. When this happens login to mysql console created a new user for mysql then flush all privileges. Check this question right here Connect to mysql server without sudo

Related Solutions

Ubuntu – Nginx installation error in Ubuntu 16.04

Shutting down apache2 first before installing nginx should fix this problem:

sudo service apache2 stop

Ubuntu – thesql doesn’t ask for root password when installing

You can recover or set root password without knowing the current one by starting mysql without loading the grant-tables.

Please note the $ in the commands. This is specifying the terminal prompt you see when typing in the command. It's showing it's a line of text, but and actual typed terminal command. The "mysql>" prefix is also a prompt. That is the prompt you get when running mysql interactivately.

This is the cli (command line) to do this:
(Be sure to stop the current server before performing the steps. Only one server can run at a time.)

$ sudo mkdir /var/run/mysqld; sudo chown mysql /var/run/mysqld
$ sudo mysqld_safe --skip-grant-tables&

Now you can log in as root without a password and perform all commands, as in this case, set the root password as root.

$ sudo mysql --user=root mysql

This is the set root password that you will perform inside mysql if you have MySQL 5.6 or below:

mysql> update user set Password=PASSWORD('new-password') where user='root';
flush privileges;

In MySQL 5.7 or above

mysql> update user set authentication_string=PASSWORD('new-password') where user='root';
flush privileges;

From there, quit (kill the running msqld) mysql and start it as normal.

Notes on starting and stopping the mysql service:

Stop mysql:

$ sudo service mysql stop

Start mysql (normal):

$ sudo service mysql start

Kill the temporary mysql safe mode session:

$ sudo mysqladmin shutdown

Best Answer

Related Solutions

Ubuntu – Nginx installation error in Ubuntu 16.04

Ubuntu – thesql doesn’t ask for root password when installing

Related Question