Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: mysql 5.7.x on Ubuntu 19.10

  1. #1
    Join Date
    Oct 2019
    Beans
    3

    Question mysql 5.7.x on Ubuntu 19.10

    Good afternoon,

    When upgrading from 19.04 to 19.10 I had some issues with mysql hanging up the installer, eventually I completely removed mysql and reinstalled. Then I found out that I now have mysql 8.x, which is a problem, I need 5.7.x for an application I develop for (Liferay 7.0). I cannot find mysql 5.7.x with apt search, so I tried installing the debs I found on the oracle download page. This gives an issue with apparmour.

    All together, a lot of hassle which I hopefully can avoid... So, the question is: how can I install mysql server (plus client) 5.7.x on Ubuntu 19.10? Is there a ppa somewhere?

    TIA!

  2. #2
    Join Date
    Oct 2019
    Beans
    3

    Re: mysql 5.7.x on Ubuntu 19.10

    I tried this approach https://dev.mysql.com/downloads/repo/apt/ but setting it to 5.7 but this gives

    Code:
    sudo apt-get update                                                                                                                                               ✔
    Hit:1 http://nl.archive.ubuntu.com/ubuntu eoan InRelease
    Hit:2 http://repo.mysql.com/apt/ubuntu eoan InRelease                                                                                       
    Hit:3 http://nl.archive.ubuntu.com/ubuntu eoan-updates InRelease                                                                            
    Hit:4 http://nl.archive.ubuntu.com/ubuntu eoan-backports InRelease                                          
    Hit:5 http://security.ubuntu.com/ubuntu eoan-security InRelease                                             
    Reading package lists... Done
    W: Skipping acquire of configured file 'mysql-5.7/source/Sources' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    W: Skipping acquire of configured file 'mysql-5.7/binary-amd64/Packages' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    W: Skipping acquire of configured file 'mysql-5.7/binary-i386/Packages' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    W: Skipping acquire of configured file 'mysql-5.7/i18n/Translation-en_US' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    W: Skipping acquire of configured file 'mysql-5.7/i18n/Translation-en' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    W: Skipping acquire of configured file 'mysql-5.7/dep11/Components-amd64.yml' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    W: Skipping acquire of configured file 'mysql-5.7/dep11/icons-48x48.tar' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    W: Skipping acquire of configured file 'mysql-5.7/dep11/icons-64x64.tar' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    W: Skipping acquire of configured file 'mysql-5.7/cnf/Commands-amd64' as repository 'http://repo.mysql.com/apt/ubuntu eoan InRelease' doesn't have the component 'mysql-5.7' (component misspelt in sources.list?)
    which makes sense because at mysql there are only 8.0 debs for Ubuntu 19.10 ... Ubuntu 19.04 had both mysql 5.7 and 8.0, I wonder why this was changed...
    Last edited by deadflowr; 3 Weeks Ago at 05:36 PM. Reason: reset fonts to forum defaults, added code tags

  3. #3
    Join Date
    Oct 2019
    Beans
    3

    Re: mysql 5.7.x on Ubuntu 19.10

    Next, try to install docker ce (to run any mysql in a container): rep https://download.docker.com/linux/ubuntu doesn't have anything for eoan

  4. #4
    Join Date
    Jan 2019
    Beans
    2

    Re: mysql 5.7.x on Ubuntu 19.10

    Following

  5. #5
    Join Date
    Oct 2019
    Beans
    2

    Re: mysql 5.7.x on Ubuntu 19.10

    same problem

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

    Re: mysql 5.7.x on Ubuntu 19.10

    This is happening to me too.
    Last edited by morhook; 3 Weeks Ago at 05:42 PM.

  7. #7
    Join Date
    Apr 2014
    Beans
    550

    Re: mysql 5.7.x on Ubuntu 19.10

    Unless you do this in docker complete with the sql that it needs staying on 5.7 is pointless. You can't expect users of your software to install old unsupported software to make yours work. Part of development is making it easy for the end user. The problem you are facing now, you do not want your users to have to deal with.

  8. #8
    Join Date
    Oct 2019
    Beans
    3

    Re: mysql 5.7.x on Ubuntu 19.10

    Facing the same problem after upgrade

  9. #9
    Join Date
    Oct 2019
    Beans
    1

    Re: mysql 5.7.x on Ubuntu 19.10

    I'm having the same problem here.
    Tried to replace mysql with mariadb which seems more compatible, but it complained about my ibdata1 file and did not start at all.
    Any help would be appreciated.

  10. #10
    Join Date
    Oct 2019
    Beans
    1

    Cool Re: mysql 5.7.x on Ubuntu 19.10

    I ran into the same issue today and got it resolved (somehow). I can't tell if this is a stable setup, so you should probably not use it in production.
    Furthermore your databases/tables may be broken due to using mysql 8. I had to load a backup of my /var/lib/mysql folder. You may get around this by dumping all databases at first, deleting them and re-importing them once you downgraded to 5.7. I can not guarantee that this approach works since I chose a different way (as mentioned before).

    Here is how i resolved it:
    1. Dump all your databases (and users)
    2. Stop the mysql service:
      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
      Code:
      /var/lib/mysql
      folder
    5. Download the following mysql packages (using the linked version is important):
      1. https://launchpad.net/ubuntu/eoan/am...e-5.7/5.7.26-1
      2. https://launchpad.net/ubuntu/eoan/am....7.27-0ubuntu2
      3. https://launchpad.net/ubuntu/eoan/am....7.27-0ubuntu2
      4. https://launchpad.net/ubuntu/eoan/am...r-5.7/5.7.26-1

    6. Install them via
      Code:
      sudo dpkg -i
      in the order listed above (the order is important!). Example: At first you run:
      Code:
      sudo dpkg -i /path/to/your/downloads/mysql-server-core-5.7_5.7.26-1_amd64.deb
      and so on...
    7. After installing the last package your MySQL server should come right up. Check this via
      Code:
      sudo service mysql status
    8. Re-import your databases and users



    I hope this approach helps you as well.


    PS: This is my first post here, so I'm sorry for a maybe ugly text-formatting

Page 1 of 2 12 LastLast

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
  •