Page 1 of 1

Upgrade to MariaDB and Php 7 on Debian 8 - How?

Posted: Thu Apr 27, 2017 2:45 pm
by robinsenpai
Hi folks, is there any valid tutorial for setuping/upgrading mysql to mariaDB 10 and to Php 7 on Debian 8?
I have fresh OS install and fresh installation of VestaCP.

Thanks for any help, and best regards, Robin.

Re: Upgrade to MariaDB and Php 7 on Debian 8 - How?

Posted: Thu Apr 27, 2017 6:03 pm
by robinsenpai
edit //
I got everything so far working and installed by following these steps:

as first backup your old mysql databases, than uset his command:

Code: Select all

sudo apt-get install mariadb-server


you will be asked after to migrate your current mysql to mariadb, press yes and follow instructions than
run mysql_upgrade (by default the install will run it), if not run it then,

Code: Select all

mysql_upgrade -u root -p
than use

Code: Select all

sudo systemctl enable mysql
and to check your version:

Code: Select all

sudo cat /var/lib/mysql/mysql_upgrade_info
for geting php7 follow this tutorial:

Code: Select all

https://forum.vestacp.com/viewtopic.php?t=13053
it had some problems with phpmyadmin, http 500 error, fixed it with:
configure apache so that it can find it correctly:

Code: Select all

nano /etc/apache2/sites-available/000-default.conf
Anywhere after "DocumentRoot /var/www/html" insert these line:
Alias /phpmyadmin "/usr/share/phpmyadmin/"
<Directory "/usr/share/phpmyadmin/">
Order allow,deny
Allow from all
Require all granted
</Directory>
Restart Apache:

Code: Select all

service apache2 restart
and final

Code: Select all

sudo apt-get install php-mbstring php7.0-mbstring php-gettext
sudo service apache2 restart
My server setup: fresh Debian 8 and last VestaCP installation:
PHP Version: 7.0.18-1~dotdeb+8.1
MySQL Version: 5.5.5-10.0.30-MariaDB-0+deb8u1
Server Software: Apache/2.4.10 (Debian) mod_fcgid/2.3.9 OpenSSL/1.0.1t / Linux

Re: Upgrade to MariaDB and Php 7 on Debian 8 - How?

Posted: Tue May 02, 2017 7:55 pm
by skurudo
Nice spet-by-step guide, robinsenpai
Thanks!

Re: Upgrade to MariaDB and Php 7 on Debian 8 - How?

Posted: Mon May 08, 2017 9:21 am
by bigmansq
Thank you for your clear instructions taigamemienphichodienthoai.net ! I appreciate your support!