So I released that I have 3 apps each user their own MySQL server. Now I want to consolidate the DBs to run only in 1 MySQL server. To move Nextcloud DB to another MySQL server I’ve
- Backed up Nextcloud DB and moved it to MySQL
- Created new DB for Nextcloud in the MySQL server
- Created new MySQL user and granted full permissions over Nextcloud DB
- Restored the Nextcloud DB into the newly created Nextcloud DB
- Modified the bind-address in /etc/mysql/mysql.conf.d/mysqld.cnf to 0.0.0.0
- Modified the Nextcloud config to point to MySQL IP address also Nextcloud DB username & password
Unfortunately I get an error when trying to access Nextcloud so I have to switch back to localhost. Can someone please help?