how to upgrade mysql

4 posts / 0 new
Last post
#1 Sun, 06/03/2018 - 14:25
livewin

how to upgrade mysql

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.

Sun, 06/03/2018 - 23:02
andreychek

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

Sat, 06/16/2018 - 13:18
livewin

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

Sat, 06/16/2018 - 13:45
livewin

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

Topic locked