Sometimes you need to change some text in a MySQL table. For example, imagine you want to correct a spelling mistake or a reference in all your WordPress posts without having to change them one by one....
Learn MoreYou may have noticed that there is no MySQL root user on servers running Plesk. That’s because Plesk renames this user into “admin” by default – for security reasons. The password for...
Learn MoreOne of my clients wanted to run a web application that required MySQL 5.5 instead of the default MySQL 5.1 that ships with Plesk at the time of writing. He needed it due to the better handling of UTF8...
Learn MoreSometimes things don’t work out with replication. When I first started experimenting with it I thought this was a “setup and forget about it” kind of job. Experience has shown though that...
Learn MoreThis is a step-by-step guide on how to replicate an existing MySQL server. The server is live and contains data and needs a constant backup companion. Many tutorials focus on how to setup replication when no...
Learn More