Database Archives - SERVERDIARY

How to SELinux allow Apache or PHP-FPM connect remote MySQL

If you have trouble apache or PHP-FPM can not connect to remote MySQSL server, example error on PDO connection on

If you have trouble when upgrading table schema or alter table on MariaDB Galera Cluster, that make your database not

By default Centos 7 repository is MySQL 5.5. If you want to use latest stable MariaDB, you need to use

Sometimes we need to update a MYSQL table data based on other table data. For example order_table field city is