Before doing anythingWe recommend you make full DA backups for easy restore, and CustomBuild mysql backups, just in case.
1) If MySQL needs to be re-installed, or wasn't installed the first time for some reason, you can re-install it with this guide. It will remove all old databases, so if you have data, make sure you back it up.
The installer uses the mysql= value for the rootpass, and the adminpass= for the adminpass, both from the setup.txt (same directory).
It may ask you:
It seems as though mysql has already been installed.
If you select "n", then the installer will fail unless the active database allows logins without any passwords. (just answer: y)
2) If you need to use RoundCube, then re-install that too:
Install MariaDB insteadIf the previous install defaults to MySQL and you want to wipe it for a specific version of MariaDB, you'd need to delete the MySQL*.rpm files, from and replace them with the MariaDB rpms before running the mysql.sh, above. You'll also need to remove the MySQL* rpms from the system after you're done creating the backups.
Adjust these values to make copy/paste quicker:
Set the values above, then run:
rpm -e `rpm -qa | grep MySQL`now you can go to step #1 above to install the MariaDB rpms.
|Running the mysql.sh is not creating data in /var/lib/mysql|
© 2018 JBMC Software, Suite 173 3-11 Bellerose Drive, St Albert, AB T8N 1P7 Canada. Mon-Fri 9AM-5PM MST