Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: mysql 5.7.x on Ubuntu 19.10

  1. #11

    Re: mysql 5.7.x on Ubuntu 19.10

    I invested countless hours in attempting to get 5.7 to run on 19.10. Once I figured out the proper order for installing the components, I invariably ran into problems starting the daemon. Here's what I got:

    Oct 29 07:01:11 Precision-Tower-3620 systemd[1]: mysql.service: Service RestartSec=100ms expired, scheduling restart.
    Oct 29 07:01:11 Precision-Tower-3620 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
    Oct 29 07:01:11 Precision-Tower-3620 systemd[1]: Stopped MySQL Community Server.
    Oct 29 07:01:11 Precision-Tower-3620 systemd[1]: mysql.service: Start request repeated too quickly.
    Oct 29 07:01:11 Precision-Tower-3620 systemd[1]: mysql.service: Failed with result 'exit-code'.
    Oct 29 07:01:11 Precision-Tower-3620 systemd[1]: Failed to start MySQL Community Server.

    After a lot of searching, I finally found the fix: It was as easy as "sudo apt-get install -f," which discovered that my system was missing libevent-core-2.1-6:amd64. Now 5.7 seems to run without a hitch. Will do further testing today.
    Last edited by bill-wilken-wilkenmail; 2 Weeks Ago at 01:40 PM.

  2. #12
    Join Date
    May 2012
    Location
    Buenos Aires, Argentina
    Beans
    18
    Distro
    Ubuntu

    Re: mysql 5.7.x on Ubuntu 19.10

    I've tried to follow the pretty thorough guide of @p4nni but it uninstalled some base components on my ubuntu 19.10 (colord gnome gnome-color-manager gnome-control-center gnome-core hplip libhpmud0 libmailutils6 libmysqlclient-dev libmysqlclient21 libsane libsane-hpaio libsnmp30 mailutils mysql-common
    printer-driver-hpcups sane-utils simple-scan ubuntu-desktop ubuntu-desktop-minimal).

    I'll try to compile from source MySQL 5.7, and get back to this thread (if I'm successful).

  3. #13
    Join Date
    Oct 2019
    Beans
    2

    Re: mysql 5.7.x on Ubuntu 19.10

    you can download and install MySQL 5.7 from MySQL download site:
    https://dev.mysql.com/downloads/mysql/5.7.html?os=2

    Documentation:
    https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html

    the only way to get your data back, is to export your database on MySQL 8 and than import on 5.7

    good luck to all of you

  4. #14
    Join Date
    Oct 2019
    Beans
    2

    Talking Simple solution

    Hello, I present an easy solution to solve the problem.
    My instagram for questions: @cleyssondarlysson
    If you have mysql 8.0 installed, follow these steps:
    1. Dump all your databases (and users)
    2. Stop the mysql service with the command:
    Code:
    sudo service mysql stop
    3. Remove the following mysql-8 related packages:
    Code:
    sudo apt remove mysql-server mysql-server-8.0 mysql-server-core-8.0 mysql-client-8.0 mysql-client-core-8.0
    4. Delete the folder mysql:
    Code:
    sudo rm /var/lib/mysql
    If you don't have mysql 8.0 installed start from this:
    5. Download the mysql 5.7 packages for ubuntu 19.10:
    Download Link: https://drive.google.com/open?id=1zD...EZUybbyMqbW4OE
    6. Extract the zip file to the same download directory
    7. Open the terminal in the download directory (where the zip file was extracted) and run the following commands in their order:
    Code:
    sudo dpkg -i mysql-server-core-5.7_5.7.26-1_amd64.deb
    Code:
    sudo dpkg -i mysql-client-core-5.7_5.7.27-0ubuntu2_amd64.deb
    Code:
    sudo dpkg -i mysql-client-5.7_5.7.27-0ubuntu2_amd64.deb
    Code:
    sudo dpkg -i mysql-server-5.7_5.7.26-1_amd64.deb
    Code:
    sudo dpkg -i libmysqlclient20_5.7.27-0ubuntu2_amd64.deb
    Code:
    sudo dpkg -i libmysqlclient-dev_5.7.27-0ubuntu2_amd64.deb
    8. Then run this command:
    Code:
    sudo apt-get install -f
    9. Alright, your mysql server must be up, run the command to verify:
    Code:
    sudo service mysql status
    10. Proceed with mysql configuration, run the following command:
    Code:
    sudo mysql_secure_installation
    11. Finally, run the command below to access mysql:
    Code:
    sudo mysql
    Edit: Updated on 11/08/2019 with the inclusion of packages for libmysqlclient-dev

    All right! Hope this helps. I am available on instagram: https://www.instagram.com/cleyssondarlysson/

    Cleysson Darlysson
    Senior PHP Developer, Software Engineer and Linux based systems administrator.
    Last edited by darlysson; 6 Days Ago at 08:42 PM.

  5. #15
    Join Date
    Nov 2019
    Beans
    1

    Re: mysql 5.7.x on Ubuntu 19.10

    Hopefully I saw this problem before upgrading. Guess the best option will be to run a mysql-5.7 docker first.

    Is there any chance to customize upgrade to not remove mysql 5.7 and do not install the version 8 ?

    I think this should be more clear on ubuntu upgrades, after all we're basically developers working with stuffs like mysql.

  6. #16
    Join Date
    Oct 2019
    Beans
    3

    Re: mysql 5.7.x on Ubuntu 19.10

    Thanks a ton! @darlysson for bringing in all details for smooth installation the only thing that's missing right now is libmysqlclient-dev for 5.7.x which currently points to 8.0.17 in eoan(Been a RoR Engineer we need this package)

    Again Thanks for helping out
    Last edited by justjuned; 1 Week Ago at 07:41 AM.

  7. #17
    Join Date
    Oct 2019
    Beans
    3

    Re: mysql 5.7.x on Ubuntu 19.10

    For installing libmysqlclient-dev 5.7.27 follow up below steps:



    Then start installing
    libmysqlclient20(don't forgot to checkout the directory where you've downloaded the above packages in the terminal)

    Code:
    sudo dpkg -i libmysqlclient20_5.7.27-0ubuntu2_amd64.deb
    Followed by:

    Code:
    sudo dpkg -i libmysqlclient-dev_5.7.27-0ubuntu2_amd64.deb
    Cheers we're done with installing libmysqlclient-dev exclusive to mysql 5.7.27

    Thanks
    !

    Last edited by justjuned; 1 Week Ago at 07:37 AM.

  8. #18
    Join Date
    Oct 2019
    Beans
    2

    Re: mysql 5.7.x on Ubuntu 19.10

    Post updated with the inclusion of its package. Thanks!

Page 2 of 2 FirstFirst 12

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •