Database

Install wordpress using remote mysql database

SETUP REMOTE MYSQL SERVER Let ip address of mysql server is 192.168.33.12 and ip address of wordpress server is 192.168.33.11 sudo apt update sudo apt install mysql-server sudo mysql_secure_installation sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf Add items shown below… bind-address = 192.168.33.12 mysqlx-bind-address = 192.168.33.12 require_secure_transport=ON # The following values assume you have at least 32M ram [mysqld] […]

Install wordpress using remote mysql database Read More »

Smooth Data Migration: Transitioning from PostgreSQL to MySQL

Introduction Database migration is a common task in the world of software development, often necessitated by changes in technology, cost considerations, or organizational needs. Migrating data from PostgreSQL to MySQL is a task that may appear daunting at first, given the differences between these two popular database management systems. However, with proper planning and execution,

Smooth Data Migration: Transitioning from PostgreSQL to MySQL Read More »

Scroll to Top