Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

install MariaDB instead of MySQL

Discussion in 'Database Discussions' started by Dev@SH, Jan 30, 2018.

Tags:
  1. Dev@SH

    Dev@SH Member

    Joined:
    Mar 11, 2014
    Messages:
    16
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    Is there a way to specify in the /root/cpanel_profile/cpanel.config file : install MariaDB10.1 instead of MySQL 5.6?

    I know there was an option in cpanel.config for: mysql-version and you could do it there but that has been deprecated in favor updating /var/cpanel/rpm.versions.d/local.versions with that information.

    I know, from the CLI, you could do
    Code:
    whmapi1 start_background_mysql_upgrade version=10.1
    and that would upgrade SQL from my default to MariaDB 10.1 but I'm trying to avoid the extra step.


    Question: does the /var/cpanel/rpm.versions.d/local.versions file get read in before cpanel install?

    Endgame: I would love to specify which version of a SQL server I am installing by default - during cpanel install. How?
     
    #1 Dev@SH, Jan 30, 2018
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,763
    Likes Received:
    1,711
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    You can simply add the following value to the /root/cpanel_profile/cpanel.config prior to starting the installation:

    Code:
    mysql-version=10.1
    This will ensure MariaDB 10.1 is installed.

    Thank you.
     
    #2 cPanelMichael, Jan 30, 2018
  3. Dev@SH

    Dev@SH Member

    Joined:
    Mar 11, 2014
    Messages:
    16
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    Thank you. Are you still recommending this even though the feature is deprecated per the docs? I'll use it, just want to make sure it's going to work for a while.
     
    #3 Dev@SH, Jan 30, 2018
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,763
    Likes Received:
    1,711
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    #4 cPanelMichael, Jan 30, 2018
  5. Dev@SH

    Dev@SH Member

    Joined:
    Mar 11, 2014
    Messages:
    16
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    #5 Dev@SH, Jan 30, 2018
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,763
    Likes Received:
    1,711
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    The modification of /var/cpanel/cpanel.config as a means of manually upgrading the existing MySQL/MaraDB version on a system is deprecated, but that's not the same file as /root/cpanel_profile/cpanel.config. You can still use /root/cpanel_profile/cpanel.config to define the version of MySQL/MariaDB installed as part of the installation process.

    Thank you.
     
    #6 cPanelMichael, Jan 30, 2018
  7. Dev@SH

    Dev@SH Member

    Joined:
    Mar 11, 2014
    Messages:
    16
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    Ok. Thank you. Problem solved!

    Can we get that a little clearer documentation?
     
    #7 Dev@SH, Jan 30, 2018
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,763
    Likes Received:
    1,711
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    I've opened internal case DOC-10246 with our Documentation Team to see if we can clarify that a little better. I'll update this thread with the outcome of the case once it's available.

    Thanks!
     
    #8 cPanelMichael, Jan 31, 2018
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,763
    Likes Received:
    1,711
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    #9 cPanelMichael, Feb 12, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - install MariaDB instead
  1. Skhilled44

    Installing mySQL and MariaDB

    Skhilled44, Jul 22, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    468
    Skhilled44
    Jul 26, 2017
  2. ferdie palero

    Install cPanel use existing MySQL or MariaDB, Apache etc.

    ferdie palero, Sep 29, 2016, in forum: General Discussion
    Replies:
    3
    Views:
    810
    cPanelMichael
    Sep 30, 2016
  3. eyanchao

    AWS Installation Error

    eyanchao, Apr 22, 2018 at 8:55 PM, in forum: General Discussion
    Replies:
    15
    Views:
    41
    eyanchao
    Apr 23, 2018 at 10:14 PM
  4. AzurelinkCP

    EasyApache 4: Unaffected means uninstall

    AzurelinkCP, Apr 19, 2018 at 11:13 AM, in forum: EasyApache
    Replies:
    11
    Views:
    73
    cPanelMichael
    Apr 20, 2018 at 9:59 AM
  5. marcuszan

    Wordpress install in addon domain directory issue

    marcuszan, Apr 19, 2018 at 8:37 AM, in forum: General Discussion
    Replies:
    3
    Views:
    66
    cPanelLauren
    Apr 20, 2018 at 6:56 AM

Share This Page