I am running CentOS Linux 6.8, Virtualmin 5.04, Webmin 1.810
Updates are current.
MySql is on version 5.1.73-7.el6
PCI compliance (Trans Armor) is asking for a minimum of 5.2 for MySql. Will this be updated in Virtualmin soon, or can / should I update MySql outside of Virtualmin?
Go to /etc/yum.repos.d and edit ius-archive.repo and for the first instance of enabled=0 set to enabled=1 and save
yum install yum-plugin-replace
REPLACING MYSQL5.1 WITH MYSQL5.5
service mysqld stop
rpm -e --nodeps mysql
rpm -e --nodeps mysql-server
yum replace mysql-libs --replace-with mysql55-libs
yum install mysql55-server
chkconfig mysqld on
service mysqld start
service mysqld status
Go to /etc/yum.repos.d and edit ius-archive.repo and for the first instance of enabled=1 set to enabled=0 and save.
REPLACiNG MYSQL55 WITH MYSQL56u IF YOU WISH OR THERE IS ALSO 57u
N.B. Do not upgrade directly from 5.5. to 5.7 according to the MySql docs you must upgrade one verison at a time.
Updating to MySQL 5.6 + when using a password on the command line i.e. for a mysqldump it throws a warning. This I found out stops Virtualmin clone and restore of the databases. The solution provided by Jamie was that there is a file /root/.my.cnf which at least in my instance contains
[client]
user=myuesr
password="mypasword"
If you remove these then restoring and cloning works.