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
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
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: 7808
Joined: Fri Dec 26, 2014 2:23 pm
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 instructions taigamemienphichodienthoai.net ! I appreciate your support!


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 2 guests

cron