Install Magento 2.1 with MariaDB

1.1k views Asked by At

Current system installed is using MySQL, going forward we decided to move from MySQL to MariaDB. MySQL service has been stopped and created new DB using HeidiSQL which comes after MariaDB installation.

MariaDB Table

Now while installing Magento 2.1, I am facing below error.

Magento Error

How do I install Magento 2.1 with MariaDB ? Currently I am using WAMPP server.

2

There are 2 answers

1
Emizen Tech On

try using localhost as the hostname in the configuration also, try creating a new user for your database with host %

0
MirzaS On

You probably need to set-up your firewall settings and open up ports for MariaDB (SQL during installation does that for you, so you didn't have to do it manually). Also add another user with privileges you need, it's never smart to use root for all of your access.

You can follow some steps on this link, for configuring remote access. It should be the same for the local configuration, at least the same ports.