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

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
robinsenpai
Posts: 2
Joined: Thu Apr 27, 2017 2:40 pm

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

Postby robinsenpai » Thu Apr 27, 2017 2:45 pm

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.

robinsenpai
Posts: 2
Joined: Thu Apr 27, 2017 2:40 pm

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

Postby robinsenpai » Thu Apr 27, 2017 6:03 pm

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

skurudo
VestaCP Team
Posts: 7511
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

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

Postby skurudo » Tue May 02, 2017 7:55 pm

Nice spet-by-step guide, robinsenpai
Thanks!
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

bigmansq
Posts: 1
Joined: Mon May 08, 2017 7:27 am

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

Postby bigmansq » Mon May 08, 2017 9:21 am

Thank you for your clear instructionstaihinhnendepnhat.net ! I appreciate your support!


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 1 guest