/ Register

Want to subscribe to topics you're interested in?
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.

Tags:
Previous Thread Next Thread
Loading...
Page 1 of 2
  1. Mar 19, 2019 #1
    eva2000

    eva2000 Administrator Staff Member

    50,891
    11,791
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,246
    Local Time:
    9:58 AM
    Nginx 1.25.x
    MariaDB 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. Sep 17, 2019 #2
    rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    7:58 AM
    Mainline
    10.2
    With 10.4 though, root login isn't possible anymore with phpmyadmin.

     
  3. Sep 18, 2019 #3
    eva2000

    eva2000 Administrator Staff Member

    50,891
    11,791
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,246
    Local Time:
    9:58 AM
    Nginx 1.25.x
    MariaDB 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. Sep 18, 2019 #4
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:58 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. Sep 18, 2019 #5
    rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    7:58 AM
    Mainline
    10.2
    Yes works fine.
    Only root user can't login to PHPMyadmin.

    With root user?
     
  6. Sep 19, 2019 #6
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:58 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. Sep 19, 2019 #7
    rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    7:58 AM
    Mainline
    10.2
    Screenshot on your PHPMyadmin please?
    With root currently login.
     
  8. Sep 19, 2019 #8
    rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    7:58 AM
    Mainline
    10.2
  9. Sep 19, 2019 #9
    pamamolf

    pamamolf Well-Known Member

    4,028
    421
    83
    May 31, 2014
    Ratings:
    +817
    Local Time:
    1:58 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. Sep 19, 2019 #10
    rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    7:58 AM
    Mainline
    10.2
    I'm installing new DO CPU Optimized server again now, just to test this again.
    Will report back.
     
  11. Sep 19, 2019 #11
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:58 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. Sep 19, 2019 #12
    rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    7:58 AM
    Mainline
    10.2
    Maybe, this could be the reason as I got new install only.
     
  13. Sep 19, 2019 #13
    rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    7:58 AM
    Mainline
    10.2
    I just installed 2 new server from DO and Vultr, both can't login as root user.
     
  14. Sep 19, 2019 #14
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:58 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. Sep 19, 2019 #15
    eva2000

    eva2000 Administrator Staff Member

    50,891
    11,791
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,246
    Local Time:
    9:58 AM
    Nginx 1.25.x
    MariaDB 10.x
    will have to investigate - it's another reason MariaDB 10.4 isn't installed on Centmin Mod by default as yet
     
  16. Sep 19, 2019 #16
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:58 AM
    1.9.10
    10.1.11
  17. Sep 19, 2019 #17
    eva2000

    eva2000 Administrator Staff Member

    50,891
    11,791
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,246
    Local Time:
    9:58 AM
    Nginx 1.25.x
    MariaDB 10.x
    yeah I am testing this on fresh centmin mod 123.09beta01 install with mariadb 10.4 default to see
     
  18. Sep 19, 2019 #18
    eva2000

    eva2000 Administrator Staff Member

    50,891
    11,791
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,246
    Local Time:
    9:58 AM
    Nginx 1.25.x
    MariaDB 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. Sep 19, 2019 #19
    rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    7:58 AM
    Mainline
    10.2
    Thanks Eva, but don't have 10.4 install right now.
     
  20. Sep 19, 2019 #20
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:58 AM
    1.9.10
    10.1.11
Previous Thread Next Thread
Loading...
Page 1 of 2

.