High power database access
This may be blocked by the MariaDB service. To fix correctly override the service file with a local copy: Edit /etc/systemd/system/mariadb.service and change ProtectHome to be false (ProtectHome=false). Save the file
This works just the same for MariaDB and MySQL. Replication means there is a master server and a slave server. I’m assuming that you have command line access to both. It is handy to set up two terminal sessions on each server. If you use Terminator, you can do that as four panes within a …
If the MySQL database is running on a different machine (whether real or virtual) from the application, a connection through a network is needed. Assuming the network cannot be assumed to be secure, some kind of encryption is needed. Various alternatives exist, the main ones being and SSH tunnel, TLS connection, VPN. Of these, the …
It is easy for replication to be upset slightly, resulting in an error on the slave that stops it operating. It then gets behind the master and manual intervention is needed. Sometimes more substantial intervention is needed, but often bypassing the error is all that is needed. Before you start, check the situation by going …
If you want to run MySQL primarily using UTF-8 then the configuration file my.cnf should contain the following directives: Check that things look right by running this command or by using phpMyAdmin to look at the “Variables” for the server, or some similar technique. which should give a result something like: Then try: which should …
If you want to check for errors in the MySQL configuration file my.conf you can start the MySQL daemon from a command line with helpful parameters: will provide a lot of information about the available parameters. More useful for diagnosing problems is: which starts up MySQL with a lot of messages – including diagnostics for …
In principle, it is possible to change the character set for all the fields in a table. But this can give problems and needs to be tackled with care. The table should certainly be backed up before attempting the change. But it is straightforward to change the collation when the character set is staying the …
Design by Dave Mcpoland
Supported by Aussie Hosting