Welcome to Centmin Mod Community
Become a Member

Beta Branch prep for MariaDB 10.4 support in 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Mar 19, 2019.

  1. eva2000

    eva2000 Administrator Staff Member

    45,991
    10,448
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,210
    Local Time:
    2:53 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    prep for MariaDB 10.4 support in 123.09beta01

    Prep work for MariaDB 10.4 support Changes and Improvements in MariaDB 10.4. Very early testing at this stage.

    Code (Text):
    mysqladmin ver                 
    mysqladmin  Ver 9.1 Distrib 10.4.3-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.4.3-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 1 min 14 sec
    
    Threads: 4  Questions: 2  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.027
    


    Continue reading...

    123.09beta01 branch
     
  2. rdan

    rdan Well-Known Member

    5,018
    1,221
    113
    May 25, 2014
    Ratings:
    +1,849
    Local Time:
    12:53 PM
    Mainline
    10.2
    With 10.4 though, root login isn't possible anymore with phpmyadmin.

     
  3. eva2000

    eva2000 Administrator Staff Member

    45,991
    10,448
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,210
    Local Time:
    2:53 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    interesting but other php/mysql using apps are fine ? might be due to drastic user/pass changes for MariaDB 10.4 outlined at MariaDB - Interesting look at what's new in MariaDB 10.4
     
  4. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    6:53 AM
    1.9.10
    10.1.11
    I'm logging tp phpmyadmin still without any problem after upgrade to 10.4
    Nothing changed on pma files.
     
    Last edited: Sep 18, 2019
  5. rdan

    rdan Well-Known Member

    5,018
    1,221
    113
    May 25, 2014
    Ratings:
    +1,849
    Local Time:
    12:53 PM
    Mainline
    10.2
    Yes works fine.
    Only root user can't login to PHPMyadmin.

    With root user?
     
  6. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    6:53 AM
    1.9.10
    10.1.11
    Yes, i 'm login to Phpmyadmin with root user.

    I didn't do anything after upgrade to 10.4 from 10.1. I though, all users migrated to new system automatically for me.
     
  7. rdan

    rdan Well-Known Member

    5,018
    1,221
    113
    May 25, 2014
    Ratings:
    +1,849
    Local Time:
    12:53 PM
    Mainline
    10.2
    Screenshot on your PHPMyadmin please?
    With root currently login.
     
  8. rdan

    rdan Well-Known Member

    5,018
    1,221
    113
    May 25, 2014
    Ratings:
    +1,849
    Local Time:
    12:53 PM
    Mainline
    10.2
  9. pamamolf

    pamamolf Premium Member Premium Member

    3,904
    390
    83
    May 31, 2014
    Ratings:
    +757
    Local Time:
    6:53 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    If i am not wrong 5.7 is equal to MariaDB 10.3 and i am using that version with Phpmyadmin with default root access with no issues.

    Didn't test it with MariaDB 10.4...
     
  10. rdan

    rdan Well-Known Member

    5,018
    1,221
    113
    May 25, 2014
    Ratings:
    +1,849
    Local Time:
    12:53 PM
    Mainline
    10.2
    I'm installing new DO CPU Optimized server again now, just to test this again.
    Will report back.
     
  11. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    6:53 AM
    1.9.10
    10.1.11
    What part do you need about screenshot ? It is unsecure

    Or do you think that i'm liar ? I don't understand exactly.

    I'm sure that and i'm not new server level user hense we are running with mariadb 10.4.8 now and i can login with root user as well.

    Our global_priv table including all of our users even root too.
    So i can login with every users at this time.

    It may related with i've switched to mariadb 10.4 from 10.1 so i though upgrade script should be replicate the users to new system. (in all reason)
     
  12. rdan

    rdan Well-Known Member

    5,018
    1,221
    113
    May 25, 2014
    Ratings:
    +1,849
    Local Time:
    12:53 PM
    Mainline
    10.2
    Maybe, this could be the reason as I got new install only.
     
  13. rdan

    rdan Well-Known Member

    5,018
    1,221
    113
    May 25, 2014
    Ratings:
    +1,849
    Local Time:
    12:53 PM
    Mainline
    10.2
    I just installed 2 new server from DO and Vultr, both can't login as root user.
     
  14. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    6:53 AM
    1.9.10
    10.1.11
    As i told before, it should be migrated from old version to new version so global_priv table including all of my mysql users now. Thats why i can login the phpmyadmin

    So, fresh new installation may need to add the root and other users manually .
     
  15. eva2000

    eva2000 Administrator Staff Member

    45,991
    10,448
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,210
    Local Time:
    2:53 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    will have to investigate - it's another reason MariaDB 10.4 isn't installed on Centmin Mod by default as yet
     
  16. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    6:53 AM
    1.9.10
    10.1.11
  17. eva2000

    eva2000 Administrator Staff Member

    45,991
    10,448
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,210
    Local Time:
    2:53 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    yeah I am testing this on fresh centmin mod 123.09beta01 install with mariadb 10.4 default to see
     
  18. eva2000

    eva2000 Administrator Staff Member

    45,991
    10,448
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,210
    Local Time:
    2:53 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    @rdan try these commands to set proper mysql root user password for MariaDB 10.4 only
    Code (Text):
    source /root/.my.cnf
    THEMYSQLPASS=$password
    mysql -e "ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD('$THEMYSQLPASS')"
    

    then try phpmyadmin root user login

    the above takes centmin.sh install generated mariadb root password from /root/.my.cnf in variable $password and assigns it to variable THEMYSQLPASS used to alter mysql root user with pre-mariadb 10.4 mysql_native_password authentication
     
  19. rdan

    rdan Well-Known Member

    5,018
    1,221
    113
    May 25, 2014
    Ratings:
    +1,849
    Local Time:
    12:53 PM
    Mainline
    10.2
    Thanks Eva, but don't have 10.4 install right now.
     
  20. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    6:53 AM
    1.9.10
    10.1.11