Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Support
  3. mysql connect in terminal not working on an old LAMP app (1.4.0)

mysql connect in terminal not working on an old LAMP app (1.4.0)

Scheduled Pinned Locked Moved Solved Support
mysqllampconsole
6 Posts 3 Posters 1.1k Views 3 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M Offline
      M Offline
      msbt
      App Dev
      wrote on last edited by
      #1

      I have this ancient LAMP app with a shop in it that is finally going to be upgraded (I know I know, but it wouldn't work on >PHP7.2). After cloning the production image to test imports and exports, I wanted to jump on the mysql console to change the urls of the shop. But when I tried to connect, this is what happened:

      mysql --user=${MYSQL_USERNAME} --password=${MYSQL_PASSWORD} --host=${MYSQL_HOST} ${MYSQL_DATABASE} 
      ERROR 2026 (HY000): SSL connection error: unknown error number
      

      I reckon this is because of the new MYSQL version you installed, do you know of a trick to connect either way? Couldn't find a real solution...

      girishG 1 Reply Last reply
      0
      • M msbt

        I have this ancient LAMP app with a shop in it that is finally going to be upgraded (I know I know, but it wouldn't work on >PHP7.2). After cloning the production image to test imports and exports, I wanted to jump on the mysql console to change the urls of the shop. But when I tried to connect, this is what happened:

        mysql --user=${MYSQL_USERNAME} --password=${MYSQL_PASSWORD} --host=${MYSQL_HOST} ${MYSQL_DATABASE} 
        ERROR 2026 (HY000): SSL connection error: unknown error number
        

        I reckon this is because of the new MYSQL version you installed, do you know of a trick to connect either way? Couldn't find a real solution...

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

        @msbt Right, the old one mysql CLI is not able to connect with new mysql 8. Best way is to upgrade to PHP 7.4 app.

        If that's not an option:

        • Grab the env vars from env | grep MYSQL
        • Then use the web terminal of some other app that uses mysql (or just install lamp 7.4). Then in that web terminal, use the MYSQL vaules from above.
        M 1 Reply Last reply
        1
        • girishG girish

          @msbt Right, the old one mysql CLI is not able to connect with new mysql 8. Best way is to upgrade to PHP 7.4 app.

          If that's not an option:

          • Grab the env vars from env | grep MYSQL
          • Then use the web terminal of some other app that uses mysql (or just install lamp 7.4). Then in that web terminal, use the MYSQL vaules from above.
          M Offline
          M Offline
          msbt
          App Dev
          wrote on last edited by
          #3

          @girish perfect, worked like a charm! Just to be on the safe side: Will the old LAMP continue working or are there any breaking changes coming up soon?

          scookeS girishG 2 Replies Last reply
          0
          • M msbt

            @girish perfect, worked like a charm! Just to be on the safe side: Will the old LAMP continue working or are there any breaking changes coming up soon?

            scookeS Online
            scookeS Online
            scooke
            wrote on last edited by
            #4

            @msbt Can you tell us what worked like a charm? Upgrading to PHP 7.4, or gradding the env vars?

            A life lived in fear is a life half-lived

            M 1 Reply Last reply
            0
            • scookeS scooke

              @msbt Can you tell us what worked like a charm? Upgrading to PHP 7.4, or gradding the env vars?

              M Offline
              M Offline
              msbt
              App Dev
              wrote on last edited by
              #5

              @scooke using the terminal of a different app to connect to the LAMP 1.4.0 database

              1 Reply Last reply
              1
              • M msbt

                @girish perfect, worked like a charm! Just to be on the safe side: Will the old LAMP continue working or are there any breaking changes coming up soon?

                girishG Offline
                girishG Offline
                girish
                Staff
                wrote on last edited by
                #6

                @msbt the old LAMP app will be left as-is. So, no change to that in the foreseeable future.

                1 Reply Last reply
                1
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • Bookmarks
                  • Search