Posts

Showing posts with the label mysql5

HeidiSQL A Simple Database Editor (MySQL/MariaDB)

Image
I love HeidiSQL as a database editing tool, It also allows me to do maintenance on my databases should the worst happen. MariaDB should automatically install Heidi SQL alongside the database engine Its taken me a few years to feel confident around editing MySQL databases but now I find it really easy to do. I have two instances of SQL servers on this PC I have Oracle MySQL 5.5.9 on Port 3306 and MariaDB 10.5.8 on Port 3007. MariaDB databases shouldn't require much housework once installed I rarely touch my databases but on the odd occasion I have to give them a quick repair. I can easily log onto to sort it with HeidiSQL and its easy to keep on top of your MySQL Server. I knew next to nothing about how to maintain an SQL server 12 years ago but I learned by reading tutorials on the Internet. HeidiSQL makes my life so much simpler I'm not having to rebuild my databases regularly like I was back