I run an Ubuntu server at work for internal purposes and updated my PHP version to 8.1. That broke PHPMyAdmin (because it was quite outdated) so I had to update it. And the process was fairly simple. Continue reading to learn how I did it.
Read the rest »
Change MySQL Password Using WAMP Server
October 20th, 2015Yesterday I found the need to change the password for MySQL (using WAMP SERVER) and realised that other people might need to do the same. So, follow these steps to change your password for MySQL when using WAMP Server.
Install Linux, Apache, MySQL, PHP on Ubuntu 14.04
March 3rd, 2015This is how I installed Apache, MySQL and PHP on my Ubuntu 14.04 server. Thanks to www.digitalocean.com for this lovely and easy to follow tutorial and www.liquidweb.com for the PHPMyAdmin integration with Apache.
Exporting All Databases Into Separate Files in Ubuntu 14.04
February 21st, 2015So today, I received a 1TB hard drive for backup purposes and decided to backup all 131 MySQL databases. I did a mydqldump of all databases but that was not good enough. What if I wanted to restore only one database?
Connecting to a Remote MySQL Database
May 9th, 2013
Every once in a while when working on a multitude websites, the need arises to allow one site to access the database of another site. This sounds like a daunting task but in reality it is not as hard as you may think. Read the rest »