3. MySQL on OpenShift 3

How to use MySQL on OpenShift 3. Additionally we show how to instal phpMyAdmin.

IMPORTANT !!!!!
Because at this moment OpenShift use PHP 7.2 and MySQL 8 there is a problem connected with the default authentication in MySQL. It should work well with PHP 7.4
Here follows 3 ways how to solve the problem.
1. When creating the MySQL instance as the value of
Version of MySQL Image
set
5.7

2. Use MariaDB in place of MySQL. You will need to Remember ONLY one thing. When creating an instance of MariaDB change the
Database Service Name
from
mariadb
to
mysql

3. If you want to use MySQL 8, you can do it but after you start the service go to the terminal of its POD and execute:
mysql -u root
and then

ALTER USER root IDENTIFIED WITH mysql_native_password BY ‘root’;
ALTER USER user IDENTIFIED WITH mysql_native_password BY ‘password’;
exit;

Of course to can choose any other values for the passwords of the root and user users.

Git repo for phpMyAdmin https://github.com/tomek-servlets/phpMyAdmin