how to upgrade mysql

Help! (Home for newbies)
1

Hi,
i like virtualmin it work very well we plan use it for production servers soon. but we need some improvements so we can use it well with all scripts. some new script as drupal require new version of mysql.
i get this message

Your MySQL server and PHP MySQL driver must support utf8mb4 character encoding. Make sure to use a database system that supports this (such as MySQL/MariaDB/Percona 5.5.3 and up), and that the utf8mb4 character set is compiled in. See the MySQL documentation for more information.
The database server version 5.1.73 is less than the minimum required version 5.5.3.

please help me to upgrade mysql or install second version and select it for virtual machine or website…

awaiting help

thank you very much.

2

Howdy,

There unfortunately isn’t a supported way to change the MySQL version.

The MySQL version you’re seeing there is the one included with your Linux distribution.

Is it an option to migrate to a distribution that includes a more recent MySQL version?

-Eric

3

Hi,
thank you very much Eric for your interest in helping me.

i used this method

nano /etc/yum.repos.d/remi.repo

i set this config

[remi]
name=Remi’s RPM repository for Enterprise Linux 6 - $basearch
#baseurl=http://rpms.remirepo.net/enterprise/6/remi/$basearch/
mirrorlist=http://rpms.remirepo.net/enterprise/6/remi/mirror
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi

after that i used this command

yum -y update mysql*

i found it upgraded but i want confirm it will work without problem ?

now i have problem of smtp is not working + imap also is not working.
virtualmin working without any problem. but i can’t connect to my email using roundcube
please help me
thanks

4

when i try login via webmail i get
connexion to imap server failed

same problem after testing smtp 25 port and 587 port i get connexion to smtp server failed
please help me

thanks