Vesta Control Panel - Forum

Code: Select all

tee -a /etc/yum.repos.d/mariadb.repo << EOF
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF

Code: Select all

systemctl stop mariadb

Code: Select all

yum -y update

Code: Select all

nano /usr/local/vesta/bin/v-list-sys-services

Code: Select all

# Checking DB system
if [ ! -z "$DB_SYSTEM" ] && [ "$DB_SYSTEM" != 'remote' ]; then
    for db in ${DB_SYSTEM//,/ }; do
        proc_name=''
        service="$db"
        if [ "$service" = 'mysql' ]; then
            if [ -d "/etc/sysconfig" ]; then
                service='mysqld'
                proc_name='mysqld'
                if [ -e "/usr/lib/systemd/system/mariadb.service" ]; then
                    service='mysql'
                fi
            fi
        fi

Code: Select all

systemctl start mysql

Code: Select all

mysql_upgrade

Code: Select all

[local@error ~]# mysql_upgrade
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
information_schema
performance_schema
roundcube
roundcube.cache                                    OK
roundcube.cache_index                              OK
roundcube.cache_messages                           OK
roundcube.cache_shared                             OK
roundcube.cache_thread                             OK
roundcube.contactgroupmembers                      OK
roundcube.contactgroups                            OK
roundcube.contacts                                 OK
roundcube.dictionary                               OK
roundcube.filestore                                OK
roundcube.identities                               OK
roundcube.searches                                 OK
roundcube.session                                  OK
roundcube.system                                   OK
roundcube.users                                    OK
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK

Code: Select all

2018-12-28  6:13:16 8 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

Code: Select all

/var/log/mariadb/mariadb.log

Code: Select all

curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash

Code: Select all

chkconfig mysql off

Code: Select all

chkconfig mariadb on